Forms not opening

[paulm]

First let me apologise if this question has already been asked. I have searched the forum and haven't found any that match my problem. Also I am not sure if I am posting this in the relevant section.

Ok now that's out of the way let me begin

We are currently running Microsoft Access 2000, which is stored on a network share.

We currently have one user that seems to be having a problem opening up certain forms in our customer database. When they double click on the form, it starts to open then nothing appears. The annoying thing is that occasionally the forms open up fine.

Initially I thought i might be a problem with the database in general. So I checked that the forms could be opened by other users. All other users can open this forms fine.

I then copied the database from the network on to the user's local drive and tried opening the forms, but we still have the same problem. The next step I tried was repairing the users installation of Microsoft Office, this had no effect. I then tried a complete uninstall and install of Microsoft Office, again no effect.

The next thing I am thinking of trying is reformatting the user's pc.

Can anyone please come up with some suggestions before I reformat the pc?

I thank you in advance for any help

 

[boblarson]

Try checking here:
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html
as it might be a missing reference error (one of the phantom type)

Also, make sure you have split the database and each user gets a copy of the frontend on their machine and the backend database is the only one on the network share. See here for more about that:
http://members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[paulm]

Thanks for your help

I will look into the references

As for splitting the database I will look into that also.

Forgive me if this is a "newbie" question . If the problem was to do with the fact that the database is not split and both the front and back end are on the network. Wouldn't it effect more than 1 user?

 

[missinglinq]

Not necessarily! This type of deployment causes many problems, including the very thing you're complaining of; some users having no problems and others having problems even opening the app. I've even seen reports of some users only being able to open the db if they follow the other users in a certain order, which may explain why your troubled user occasionally has no problem opening the app.

Another common problem with this type of setup is that it frequently causes repeated episodes of corruption.