Limiting DAO Access
Posted on 1999-01-20
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.