I have built a checkbook application for our office.
We run WIN NT4.0 at work and I have domain admin priv
I have a MSAccess 97 db on \\computer1\checkbook\master.mdb
The folder is shared and all permissions are set to EVERYONE right now.
The I built a front end using MSAcess97 called CHECKBOOK.mdb that has tables that link to the DB on \\computer1\checkbook\master.mdb
The problem I have is that I can log on to any computer that has the checkbook.mdb front end and I am able to see the data, update the data on the master database. I can even have multiple instances of the front end open, no problem.
Howvever, when I give the front end to "Joe User" who has just normal priv on the domain, they get the error that the database is in use by someone else, or that they need the rights to use it!!
How do I do this....? I thougth it was a permisson problem on the NT side, but after reading some of the other questions here, I think it is a Access DB rcordset locking problem!