Dave, visit Tony Toews' site at:
http://www.granite.ab.ca/accsmstr.htm
His "Performance" page has a number of good suggestions on how to tackle
this.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Dave Willock" <davewillock@hotmail.com> wrote in message
news:13cc90f0.0310210214.31497167@posting.google.c om...[color=blue]
> After splitting a database into the standard "Front end" " Back End"
> set-up the performance on the database has deteriorated to an unusable
> / unacceptable level - this occured as soon as the database was split.
>
> I'm using access 2000 SP3.
>
> When the database is run as a single combined database the performance
> is absolutly fine.
>
> Has anyone come across any issues like this and could point me in the
> direction of a fix ?
>
> Thanks in Advance.
>
> Dave Willock
> IT Development.[/color]
