Read-Only Database!

[Olivier]

Dear Reader,

I created a database in Access 2007 and shared it over the network, however
I am the only one supposed to update, modify and change database and would
like just others just to read the database; how can I make the database
read-only on the network and be able to change it on my end? Please help.

Thank you

 

[Keith Wilby]

Dear Reader,

I created a database in Access 2007 and shared it over the network,
however
I am the only one supposed to update, modify and change database and would
like just others just to read the database; how can I make the database
read-only on the network and be able to change it on my end? Please help.

Thank you

The easiest way would be to use file permissions to grant read only access
to the mdb file.

Keith.
www.keithwilby.co.uk

 

[Olivier]

The easiest way would be to use file permissions to grant read only access
to the mdb file.

Keith.
www.keithwilby.co.uk

Dear Keith,

Thank you for your reply but how will I achieve that?

Thanks

 

[Keith Wilby]

Thank you for your reply but how will I achieve that?

Right-click the mdb file in an explorer window and choose "Security".

 

[Douglas J. Steele]

Right-click the mdb file in an explorer window and choose "Security".

Just a comment, Keith. The OP stated that this was Access 2007. If the file
is in ACCDB format, then Security isn't an option.

 

[Chris O'C via AccessMonster.com]

I usually run on Linux, but I have a drive that runs Windows XP. After I
upgraded it to sp3, I didn't use it much so it took me a while to realize
Windows XP sp3 doesn't have security in the file properties window anymore.

Chris

 

[Chris O'C via AccessMonster.com]

I think Keith means file level security, not Jet (Access) security.

Chris

 

[Keith Wilby]

I usually run on Linux, but I have a drive that runs Windows XP. After I
upgraded it to sp3, I didn't use it much so it took me a while to realize
Windows XP sp3 doesn't have security in the file properties window
anymore.

That just goes to show how much I use it too because I could have sworn it
was there but I have no way to check here. I thought that it was there
provided that the "simple file sharing" option was off.

Keith.