Access 2000 Split Database Performance issues.

[Dave Willock]

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.

[Allen Browne]

Re: Access 2000 Split Database Performance issues.

Dave, visit Tony Toews' site at:

http://www.granite.ab.ca/accsmstr.htm

His "Performanc e" 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@ho tmail.com> wrote in message
news:13cc90f0.0 310210214.31497 167@posting.goo gle.com...[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]