Splitting Databases

[Hall Ted]

I have tried to split databases, and it does what I want,
howver I have found that linking to other databases on
the network makes access databases run very slow. If I
have the everything in the data base in the folder and
star it my for loads within about 5 seconds. When I
split the database and it links it to the tables, even if
they are in the same folder on the network it takes about
1 minute to open the same form. Does anyone else have
this problem, and are there any ideas?

 

[Albert D. Kallal]

Often, when you split a database, it runs slower.

However, you can have the front end part open a table to the back end table.
You want to KEEP this connection open. So, in your start-up stuff, open a
table, even a tiny little one.

Doing the above usually restores most of the performance loss. Remember, you
are planning to install a mde front end on EACH pc, as that is about the
best solution in terms of reliability (anything else tends to be full of
problems).

For more tricks like the above persistent connection, you also want to check
out the following list of things that can effect performance:

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