<div>
I'm using the following code, and I get the same message.:<br />
<br />
<br />
Records.Open(dbOpenDynaset<wbr />, NULL, dbReadOnly);<br />
<br />
Where Records is a CDaoRecordset Object.<br />
<br />

</div>


I'm using the following code, and I get the same message.:


Records.Open(dbOpenDynaset, NULL, dbReadOnly);

Where Records is a CDaoRecordset Object.



<div>
<div class="content wysiwyg-content">
I have an Access database from where users need to access information. They do not need to append or edit any information, only read it. I wrote a program using CDaoRecordset for the users to retrieve the information.<br />
<br />
The problem is that if I set the mdb file as read only so that users can't delete, add or change the records, the<br />
Open() member function responds &quot;... Cannot open file ...It is already open exclusively by another user.&quot;<br />
<br />
Only if I give the users read and write access does the program work. But I don't want people to be able to change the database, i.e. with MS Access for example.<br />
<br />
Is there a way to do this and get rid of that message.
</div>
</div>


I have an Access database from where users need to access information. They do not need to append or edit any information, only read it. I wrote a program using CDaoRecordset for the users to retrieve the information.

The problem is that if I set the mdb file as read only so that users can't delete, add or change the records, the
Open() member function responds "... Cannot open file ...It is already open exclusively by another user."

Only if I give the users read and write access does the program work. But I don't want people to be able to change the database, i.e. with MS Access for example.

Is there a way to do this and get rid of that message.

Limiting DAO Access

Kernel and system programming is the process of creating the software necessary for a computer or device to function and operate other programs. Some operating systems (such as Microsoft Windows) are proprietary, but others, such as the various Linux distributions, are open source.