Locking a Database

[bullfrog]

I have a company wanting to asses my database and i am willing to show them but i need to be able to lock the database so that they can view it but cannot edit anything in it either adding deleting or plan editing. How can i do this.

Bullfrog
The Amateur

 

[still_rookie]

You dont need to lock the database,

just make a replica.

You can do this by -

Tools -> Replication -> create replica

did that help ?

 

[bullfrog]

Thanks that helped but they can still edit and add records and i also want to make sure they can really only view it

 

[still_rookie]

ok then from the form properties, set the following properties to 'No' :

1.Allow Edits
2.Allow Deletions
3.Allow Additions
4.Data Entry

 

[ghudson]

ok then from the form properties, set the following properties to 'No' :

1.Allow Edits
2.Allow Deletions
3.Allow Additions
4.Data Entry

In addition to that I would create a MDE version of your db to protect the design of your objects and your VBA.