Question How to make a Read-Only Clone of a db

[bsnalex]

I've recently started in my post and I've inherited a slew of pretty big databases from my predecessor, who, unfortunately did not leave a user guide on where everything is (there's around 85 pages of code).

The main database contains patient records. It has a clone that is a read-only version, just looking at the front-ends without editing any records. The problem is the users of Access '07 can't view any records (the form with the records that you can scroll through has blanked-out fields).

I thought I would do away with the old read-only db and just clone the current writeable database and make it read-only. I've tried going through the User-Level Security Wizard, making myself full user as admin and creating another username in the read-only group. The records show up, however, if you want to search for a record you can't because clicking the "Find" button after you enter the Patient ID or Patient Name, executes "SaveRecord" and then searches, instead of just searching-- obviously, you can't Save the record if you're a read-only user.

Is there any easy way to just make a database read-only? I can't do it through Windows bc it's too vulnerable.

Thanks in advance for any help.

 

[llkhoutx]

Use Access security under Tools>>Security.

Make a copy before you try this so you don't lock yourself out.