Access 2000 Startup Question

[Ray1127]

Explanation: I have an Access 2000 Database split into a front end and a backend. The backend is on the server and the frontend is distributed to the various users.

Question: When I install the front end to a users machine and Open it the frontend database hangs. The only thing it is doing is loading the startup form which is a simple data entry page. If I kill the process and re-open the frontend it works fine. This happens on every PC. Anybody have an idea why this happens and is there a fix for it.

 

[alvechurchdata]

That's an odd problem. Just a few thoughts:

Is the startup form sharing a table or perhaps trying to open it exclusive?

Is it trying to reach a mapped drive and having to wait for something to time out?

Can you single-step the opening of the form to see where the delay's coming from?

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[Ray1127]

The startup form shows and allows the user to update a linked table in the backend Access DB on the server.

The path to the linked server does not include a mapped drive it is as follows:

\\server1\scsi_1\ANOC\ANOC_BE.mdb

There is no code in any of the events that execute when the form is opened. The only code behind the form is on 3 command buttons that do the following.

1. delete the current record. (only exists on the manager's PC)
2. Open the Report Form
3. Exit the application

Otherwise the form uses the scroll bar at the bottom of the screen to move to the first, previous, next, last and new records. It also uses the Binoculars in the menubar to search for a specific record. (Uses the inherent access functions so no code behind those options.)


The part that I don't understand is it only occurs the first time the DB is opened on each machine. After that it works with no problem. (Although occasionally it will open slowly but it does open correctly. In those instances it can be traced to network issues.)