S_s_s_sslow Access

01-12-2004, 10:58 AM

I have a application using an Access Database that works good on my local machine. I have other computers here than can access the mdb file over a network, but that's where things really slow down.

I'm using an ADO connection and I have no databound controls, just a bunch of SQL queries.

Here's my connection string

sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source =" & strSettingFile & ""

strSettingFile is a variable holding my path and mdb file.

any direction on this would be greatly appreciated.



01-12-2004, 12:02 PM
An access query is ALWAYS client-side, as there's no DB server. This means that an ADO query must copy the entire table to the target machine, then run the query locally. Queries with multiple tables must make a local copy of all the tables involved before the query can run.

On a local machine, the same thing is taking place, but all the data is transferred internally, therefore the query runs much faster.

I once had an access query that was updating 300 records a second when the data file was on the C: drive slow down to 1.5 records a second over the network.

01-12-2004, 12:18 PM
So does this mean I'm stuck with slow access or is there a work around or different connection?

01-12-2004, 12:25 PM
You could try to move the MDB file to a file server that has a little more "umph" to it or you could switch to something like SQL Server, which is a server based DB Engine that supports server-side cursors.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum