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.

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

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

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


"Robin Guest" <(E-Mail Removed)> wrote in message
news:1d07e01c42301$9c249880$(E-Mail Removed)...
> 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.
>
>
>

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...


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(E-Mail Removed)
http://www.attcanada.net/~kallal.msn