Split Database

[pthoopth]

I hope someone here can help me because I've been working on this for a few days now and it's driving me insane!!!

I have an access 2007 database with forms and queries...etc. I install runtime on users machine and have a shortcut that uses the following switches

/runtime /ro /X "OpenMain"



This allowed the users to view the data only and did not lock up the database. If they tried to modify the data the machine would beep and nothing would change.

Now I have split the database and even thought it says it is in read only mode when they run the app with these same switches...it allows them to change the data.

Is there any way around this?

[NTC]

yes - assuming they view data via a form in their front end (which is the way it should be) and you have the back end file not visible to them (database window not visible) so that they can not go directly to table object; then lock the fields of the form via the form's properties
Additions NO
Edits NO
Deletes NO

[pthoopth]

Thanks for you reply. So it should be a different form for viewers? Wouldn't locking the form that everyone sees also lock out people who need to edit?

[NTC]

its your design choice

one front end design - with some sort of ID logic so that some users can edit and some can not - - you change the form properties depending on ID

or

two front end designs - - give one that allows edits to some people and one that does not allow edits to others....