Database is sluggish once split

[Robin Guest]

I have recently split a fairly complex database which for
some time 5/6 users had been accessing simultaneously on a
server.

Now the dynamic tables are in a back-end and the rest in a
front-end the front-end application runs much slower than
the previous 'unsplit' database if there is more than one
user connected.

(The tables used in the front end are linked to the back
end, both are mdbs.)

The start-up for example takes twice or even 3 times
longer.

Have I missed a trick?

Thanks for your help.

 

[Cheryl Fischer]

Have a look at MVP Tony Toews' Performance Tips at:

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

 

[Albert D. Kallal]

If you keep a connection open to the back end at all times...most, if not
all of your performance will be restored.

Also...check out the link Cheryl mentioned...