how to speed up access?

[Dug]

hi,

I have a base splitted in a front-end and back-end.
the fe is on the local harddrive et the be on the network harddive.

My question is: Is there a way to speed up connection or something
else to make the froms openning faster ?
The purpose of the base is to make a planning. Given a week, the base
permit to put some task on a list of name.
This work well but it is soo slow, particulary at the first opening of
the form. ( And each time it is re-opened).

any suggests ?

TIA

[Allen Browne]

Re: how to speed up access?

If this is Access 2000 or later, see Tony Toews':
Access Performance FAQ
at:

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

There are several issues to address, especially Name AutoCorrect and
subdatasheets.

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

"Dug" <dug8C@hotmail. com> wrote in message
news:1999b9d8.0 404140550.13912 bb3@posting.goo gle.com...[color=blue]
>
> I have a base splitted in a front-end and back-end.
> the fe is on the local harddrive et the be on the network harddive.
>
> My question is: Is there a way to speed up connection or something
> else to make the froms openning faster ?
> The purpose of the base is to make a planning. Given a week, the base
> permit to put some task on a list of name.
> This work well but it is soo slow, particulary at the first opening of
> the form. ( And each time it is re-opened).[/color]

[Dug]

Re: how to speed up access?

thanks, this is what I was looking for :)