Access database slow

Sylvain Finardi

• 17 de marzo de 2021 15:29

Hello,

I've an Access database (accdb) on a network share with around 1 million of records.

I'm using Bartender 2016 to access it without any problems. When I access the records through the Bartender file, it takes 1 seconds to show the selected record with a filter.

When I am using 2021 version, it takes 30 secondes to access the same database with the same bartender file and same filter.

Have you already experienced this issue ? I've followed this KB https://support.seagullscientific.com/hc/en-us/articles/360023695493-How-to-fallback-and-force-BarTender-to-use-the-Microsoft-Access-Database-engine-driver-OLEDB-JET-in-BarTender-2019-and-later but it's not working...

Thanks for your help.

PS : if I remove some records from the database, the time to access it decrease, that should implicate that a lot of data are read to access database...

0

• 

  Sylvain Finardi

  ★ BarTender Hero ★

  • 18 de marzo de 2021 09:10
  • Editado

  The documentation linked above is not correct.

  You must enter "Preferred Access Provider" for Access databases (.accdb). Excel is only for Excel sheet.

  [HKEY_CURRENT_USER\Software\Seagull Scientific\BarTender\Preferred Database Providers]
  "Preferred Access Provider"="OLE DB"

  Just restart Bartender and now the record accessed is displayed in 1 or 2 seconds. Same as before. No need a reboot.

  0

Iniciar sesión para dejar un comentario.