Database Lock

  • Thread starter Thread starter Aine McElroy
  • Start date Start date
A

Aine McElroy

Hi All,

I was wondering if you can help me it may be a very silly question but here goes:

I was asked to 'lock' one of my databases (I am used to creating databases not finishing them). I have searched the internet and my access book and I really can't seem to be able to find how to actually 'lock' the database. I am assuming the the DB can be reviewed on a read only access but no additions, edits or deletions can be performed. I would really appreciate anyone's help on this.

Many thanks
Aine
 
Well, the requestor needs to qualify what they mean by "lock." If they mean
add security, you can do that via creating Workgroup Security (mdw file).
However that method has been elliminated as of MS Office 2007. If they mean
that users cannot create new forms or modify existing forms, deploying an MDE
version of the database would be sufficient. If they want it totally locked
down from changes and you can't won't use the MDW method, you can create an
ADP/ADE project version and deploy that. I don't have any liks to the
specifics of any of these options, but I'm sure someone else can provide
those, or armed with this info, you can probably research it yourself.

Good luck.
 
Back
Top