Can you set access to always open files read only

[Guest]

I have been asked to investigate whether it is possible to configure Access
so it only opens files read only.
In other words end users will be able to open there existing files but will
no longer be able to create new Access databases.
I think what the management are after is in effect an access viewer which I
do not believe exists. If anyone knows and options / registry settings etc
that would force Access to open files read only that would be very useful.

Thanks

 

[Douglas J. Steele]

If you limit their access to read-only on the folder where the MDB file
exists, they won't be able to make any updates to the file.

 

[Joseph Meehan]

If you limit their access to read-only on the folder where the MDB
file exists, they won't be able to make any updates to the file.

Or you can set user level security or just password security to
accomplish it. Frankly I like Mr. Steele's suggestion.

 

[Arvin Meyer [MVP]]

You can set user-level security to allow only read-only access.

http://support.microsoft.com/download/support/mslfiles/SECFAQ.EXE

You can lock forms to prevent editing data. You can create a runtime version
and make the data on the server read-only. Like-wise you can do the same
with an MDE.

Of all the choices, the first is the most effective.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com