Problems - Users accessing database in Access 97 and XP

[WH2O]

Help.

I've created a database of information that can be viewed (but not modified) by anyone in the office. Because some computers are running Access 97 and others XP (and even a few on 2000), I created the database in Access 97. Everyone has an icon on their screen which they can click, and most of the time, regardless of what version of access they have, the database comes up in switchboard screen format where they click on what report they wish to view.

Today, it is not letting anyone in who is running Access XP. An error message pops up saying something like: "the database you are trying to access is currently in use or you do not have permission to access it exlusively"

I've checked every computer in the office, and the database is not in use.

Can anyone tell me why most of the time this message does not come up, and therefore why it is coming up now? Have I inadvertendly changed something?

This has happened before, but as far as I can tell, went away on its own.

Assistance appreciated!

WH20

 

[Junior1544]

On a computer this is happening on, Check to see if the ldb file is there(especialy if no one else is in the db)...

If it is there, Try to delete it...

next make sure that all the users have access to read and to write and erase a file from the directory... maybe one of the users doesn't have permision to delete the ldb, so that computer is causing the ldb to get 'stuck' there causeing other people to have a problem...

These are just idea's off the top of my head... hope it helps.

--James
junior1544@jmjpc.net
Life is change. To deny change is to deny life.