Linked Tables

[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?

 

[Allen Browne]

Follow through the list of things Tony has here:
http://www.granite.ab.ca/access/performancefaq.htm

The split database will be a little slower, but should not orders of
magnitude slower.

 

[Klatuu]

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.

 

[Allen Browne]

Good pickup, Dave.

That possibly means multiple users are in the same front end also.

 

[Klatuu]

Could be. And that would only make it worse.

 

[Rod]

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.

 

[Tony Toews [MVP]]

Front-ends will, of course, be on local machines once the database is
in production.

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/