Access database slow 追蹤

0
Avatar
Sylvain Finardi

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...

1 意見

0
Avatar
Sylvain Finardi
評論操作 永久連結

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.

登入寫評論。