Split database now very slow

  • Thread starter Thread starter WC Justice
  • Start date Start date
W

WC Justice

I have several Access 2000 databases that I have split in order to more
easily distribute changes/improvements to the front end. I ran into some
trouble importing forms from one into another because of the Currentdb
method.

The main point is that once I split the first database, it slowed down
tremendously, especially when opening forms. Both the front end and back
end are on a server, so I tried putting the front end on a client, but
noticed no improvement.

I have Service Pack 3 installed (on the client), am running Windows 2000
Server and XP Professional.

Any ideas?
 
It is quite common to experience that slowdown.

However, if you keep a connection open to the back end then performance is
usually restored to levels very close to un-split.

So, try opening a table in the front end to the back end (any table..but
just keep it open).

Try the above tip. It usually fixes things. For the above, and a few more
tips..check out:

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