I have a MS Access 97 database that is used by a lot of people on a network. The problem is there are a few people that have Access 2000 on the computer and if someone is already in the database they cant open it on their computer. Does any one know if there is a way around this?
When you say it is used by a lot of people on a network, do you mean they all access it individually ie. one at a time or can it be accessed by multiple users at the moment? Or is it just the Access 2000 users that cant access it? If you can give me some more info I can tell you how to get round it.
It is to do with the file locking methods used by the different versions. What error message does the Access 2000 user get when trying to open the 97 database? Did you convert the front end (.mde)into Access 2000 or are you running the 97 verions on the 2000 machines? Its not all lost just yet!!
If you email me off-list at [email protected] I will explain what I mean. There is a distinct process needs to be done in order for different versions of Access to use a database across a number of users. It is fairly straightforward, but it needs a bit of explaining. It is possible to have both an Access 97 version and Access 2000 version. Have done it myself and it works.
This thread is now locked and can not be replied to.