help to make non editable database

[mazen911]

hi guys i am still new in database
i did databse with tables and forms and i want to make a copy of it that can not be edited or type in data in it i mean to show that databse for others and to check it without using it or change it.
thanks

 

[John Big Booty]

Perhaps the article here will give you some pointers.

 

[mazen911]

thanks for reply but i am using office access 2010 and can not find that option

 

[John Big Booty]

Try this link then.

 

[mazen911]

Sorry I read the link but couldn't make a copy which is in disable non editable mode so how can I do

 

[Pat Hartman]

Short of significant programming effort, I know of only two ways to make this happen and one may require program changes anyway.
1. Upsize to SQL Server. You can use its security to control read/write access to tables.
2. Change the DOS file permissions for the BE database. Limit some users to read only. I haven't tested this method so it may cause you some problems. You need to make sure that your code doesn't change things behind the scenes. Some apps create log records as users do things and this would not work in this case.

All in all, the best solution is going to be SQL Server because the Access security model doesn't support this type of security any more.