Les requêtes ACCESS (2003) ne sont pas visibles sous Bartender 2021

Michel KLUKASZEWSKI

• 31. März 2022 14:23
• Bearbeitet

Bonjour,

Les requêtes ACCESS (2003) qui étaient visibles sous Bartender 9.3 ne sont plus visibles sous Bartender 2021 où seuls les tables sont visibles.

Comment résoudre le problème ?

Michel

 

************************************************************************************************************

 

Good morning,

ACCESS requests (2003) which were visible since Bartender 9.3, are no longer visible since Bartender 2021, whether in .mdb (oledb access) or in .accdb (native access).

How to fix that?

Cordially,

Michel

0

• 

  Xabier Clemente

  Moderator

  ★ BarTender Hero ★

  • 5. April 2022 09:41

  Hello Michel,
  
  Welcome to the BarTender Community!
  
  BarTender 2021 should have no issues connecting to Microsoft Access databases.
  
  If you are using an Excel database or Access database connection, you will need to have Office installed; and its version will need to match the bit version of BarTender, so both will need to be on either 32/64-bit version. You can learn more in the following article. 
  
  Could you confirm this is the case for us?
  
  Thank you!

  0
• 

  Michel KLUKASZEWSKI

  ★ BarTender Hero ★

  • 6. April 2022 08:27

  Bonjour,

  Merci pour votre attention.

  Je confirme qu'en installant la version 32 bits de Bartender face à un Access 32 bit les requêtes sont maintenant visibles que ce soit en OleDb ou en ODBC. Par contre il reste des erreurs lors de la visualisation des enregistrements. Je pense que la requête est trop complexe et / ou non totalement standard SQL.

  J'ai transformé ma requête en table pour pallier à tous les messages d'erreurs.

   

  Cordialement,

   

  Michel

  **********************************************************************

  Good morning,

  Thank you for your attention.

  I confirm that by installing the 32-bit version of Bartender against a 32-bit Access, the requests are now visible whether in OleDb or ODBC. On the other hand, there are still errors when viewing the recordings. I think the query is too complex and/or not fully standard SQL.

  I transformed my query into a table to overcome all the error messages.

   

  Cordially,

   

  Michel

  0
• 

  Xabier Clemente

  Moderator

  ★ BarTender Hero ★

  • 6. April 2022 09:28

  Hello again Michel,
  
  Thank you for letting us know using the same bit version fixed the visibility issue, we are glad this made the requests visible again.
  
  If you have any further queries or issues with BarTender, please feel free to reach us again.
  
  Have a nice day!

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.