Unanswered: Accessing linked tables in catalog is very slow
I was wondering if anyone can help - I have a Microsoft Access (2002) application that's split into a frontend and a backend.
Basically, the location of the backend is stored in an .ini file, and every time the frontend is started it reads this file, checks the table links, and if they're different to the location in the .ini file then it relinks them.
This is all fine and dandy on a single-user system, but when someone else is using the backend database at the same time it becomes very slow (2-3 minutes) to check the table links, or indeed to access anything in the 'Tables' collection of the catalog.
This doesn't make any sense, as I am opening a connection to the local (frontend) database, and it shouldn't be trying to access the backend at all as I am only trying to find out where the frontend table is linked to.
Here is my code:
Dim adoCNN As ADODB.Connection
Set adoCNN = New ADODB.Connection
.Provider = "Microsoft.JET.OLEDB.4.0"
Dim adoCat As ADOx.Catalog
Set adoCat = New ADOx.Catalog
Set adoCat.ActiveConnection = adoCNN
All this is fine, but I get a long delay when I try to access any property of the tables collection...