Making a Read Only database from an editable database

[paoconnell]

Here's the deal. My customer edits an Access database that contains data that many other people would like to access or query. The deal is, we don't want those other people to be able to modify that database. While I have developed a way for the users to view the data in either read-only or editable mode (using the Switchboard), I want to be able to create a database from today's database that will be read only. I'm aware of MDE databases, which keep people out of the code and forms design, but I'm looking for a "switch" that will turn off writing in the MDE database.

Ideally, my customer would just run a macro that creates the MDE. I'm aware of conditional compilation, which could change the behavior of the Edit Data buttons in the Switchboards. The question is: is this the right approach or is there a simpler way?

 

[Francescina]

I fear that the only professional solution is to activate the security system on the database.

 

[KenReay]

Hi

Do you mean that you want a 'snapshot' of todays data, which is read only, and that the 'updatable' database is a seperate mdb, which continues to be updated?

If yes, just set make a copy of the 'updatable' mdb, set the read only property. Users will get a warning message saying is is readonly but it will still run.

Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use

 

[paoconnell]

KenReay--

Setting the "read-only" property would work just fine, except that any user can make the file writable again if they have privileges to do so.

Still thinking about this...

Pat O'Connell