linked tables cause slowdown

[Michael S. Montoya]

Every instance that I split tables and forms into a frontend/backend
situation, the database instantly grows slower. Even the initial load time
(even if the opening screen contains no data) is drastically slower. I have
even tried moving the front end to each users workstations while keeping the
MDB with the datafiles on the server, and this does not seem to increase the
load/processing time.

Is this a known trait of splitting a database? Are there any workaround? I
have heard something about using MSDE (if the client can't afford SQL server
or if the job isnt large enough to warrent SQL) Where can I get information
on this proceedure?

 

[Nikos Yannacopoulos]

Michael,

Splitting and distributing a local copy of the FE to each user is indeed the
right thing to do in a multi-user environment. It is also known to cause the
delays you mention, but there are some tricks that can speed up the app
spectacularly! Have a look at Tony Toew's page:

http://www.granite.ab.ca/access/performancefaq.htm

It's been a life saver to me, and many others from what I read in the NGs.

HTH,
Nikos