Linked Tables

  • Thread starter Thread starter Rod
  • Start date Start date
R

Rod

A single .mdb file, containing tables, queries, forms and code, runs at an
acceptable speed whether from a local drive or from a network drive.

Split the file, moving the tables to a back-end and then linking them to the
front-end, and it runs incredibly slowly. A query which ran in under a second
now takes over a minute!

Running the single file off a network drive works fine. Split the file,
placing front-end and data in the same network directory, and it grinds to a
halt.

I am very familiar with Access and have done this many times before with
success. Can anybody suggest some pointers as to what is causing this
dramatic slowdown?
 
Note the OP said both the front and back ends are on a network folder. This
is going to dramatically increase network traffic and thus slow the
application.

It would be much better if the front end is on the user's computer.
 
Good pickup, Dave.

That possibly means multiple users are in the same front end also.
 
Thanks Allen and Klatuu.

I mentioned the file being on a server to demonstrate that running it as a
single file on a server runs far faster than as split files on a server -
i.e. that network speeds were not, of themselves, a noticeable contributing
factor. Front-ends will, of course, be on local machines once the database is
in production. I am also currently trying to run the front-end on my local
PC, but with these disastrously slow results.

Allen, I will refer to the link you have given and get back if necessary.
Thanks.
 
Rod said:
Front-ends will, of course, be on local machines once the database is
in production.
Click to expand...

I created the Auto FE Updater utility so that I could make changes to
the FE MDE as often as I wanted and be quite confident that the next
time someone went to run the app that it would pull in the latest
version. For more info on the errors or the Auto FE Updater utility
see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top