Discussion Locked

Ms-access 2000 problems

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a Novell 3.12 server that stores and ms-access database (access 97) used by 4 users with different OS on each workstation: (2)win95,(1) win98 and (1)win NT on the last PC. Those 4 users used to share that database and were able to access it at the same time. 2 weeks ago I upgraded those pc's to MS-access 2000 and since then only one user can connect and save at any given time. If another user try to connect to that database he/she gets an error message stating that:" Exclusive access to the database could not be obtain...etc". All 4 users have full permission to this particular shared folder on the network drive. I've tried to review all the rights and priviledges and everything seems to be fine but still no more than 1 user can get access to that share folder at any given time. The first user to get access locks out the others.

Any hints would be greatly appreciated.

Anticipated Thanks for your help,

Nyko

1 reply

by thomas.white

Did you upgrade the access database to the new version. All access 97 databases need to be upgrade unless end user still have access 97 on their machine. And i have to tell you, you are a brave person to run novell 3.12 and win 9X of any kind. I used to have nightmares with my setup like that. To upgrade you can open access 2000 (no database) and go to tools, database utillities, convert database, and click to current access database version. Chose the file you want to convert and save it(making sure to make a backup copy of your original)to the same name on that novell share. That should allow multiple access. If that does not help make sure you have it set to share in the options settings.

This discussion is closed to new replies.