<div>
Thanks. I did get it to work finally, but only after I logged on to Joe Users compter as me and then had him log in...weird<br />
<br />
But you put me on the right track so here's the points
</div>


Thanks. I did get it to work finally, but only after I logged on to Joe Users compter as me and then had him log in...weird

But you put me on the right track so here's the points

<div>
<div class="content wysiwyg-content">
I have built a checkbook application for our office.<br />
<br />
We run WIN NT4.0 at work and I have domain admin priv<br />
<br />
I have a MSAccess 97 db on \\computer1\checkbook\mast<wbr />er.mdb<br />
<br />
The folder is shared and all permissions are set to EVERYONE right now.<br />
<br />
The I built a front end using MSAcess97 called CHECKBOOK.mdb that has tables that link to the DB on \\computer1\checkbook\mast<wbr />er.mdb<br />
<br />
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.<br />
<br />
Howvever, when I give the front end to &quot;Joe User&quot; 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!!<br />
<br />
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!<br />
<br />
Thanks<br />
<br />

</div>
</div>


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!

Thanks



Access 97 recordset locks/permission

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.