Form Opening - Delayed Response

I am using an Access 2000 database on a small (7 computer) network (operating
system is XP Pro). The problem I have is related to the speed with which
forms open.

The database is configured with the front-end on each workstation, and the
back-end on a single machine. The system works fine when a computer opens a
form; however, if a second machine opens the same form, there is a measurable
time delay (sometimes more than 15 seconds) between selecting the form and
when it opens on the screen.

I am using record locks so that two users can’t edit the same record.

This isn’t a “network� problem per se, as I am running other multi-user
applications and don’t have any time delay problems.

Any suggestions of where to look?

Thanks.

--
Mark B

The simple answer is to make sure you have a persistent connection from the
back end to the front end.
(this means in your startup code in the front end, open a connection (a
table) in the back end....and keep it open).

Do the above, and your delay problems will go away.

You should also turn off track name auto correct, and really, even better is
to distribute a mde to each station.

The above two tips, and a bunch more can be found he

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


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

http://www.members.shaw.ca/AlbertKallal