Home All Groups Group Topic Archive Search About

Read-Only Database!

Author
19 May 2009 9:55 AM
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

Author
19 May 2009 10:41 AM
Keith Wilby
"Olivier" <Oliv***@discussions.microsoft.com> wrote in message
news:1FF5110B-6379-410C-83A5-4B7544ACEC0A@microsoft.com...
> 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
Author
19 May 2009 11:06 AM
Olivier
Show quote Hide quote
"Keith Wilby" wrote:

> "Olivier" <Oliv***@discussions.microsoft.com> wrote in message
> news:1FF5110B-6379-410C-83A5-4B7544ACEC0A@microsoft.com...
> > 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
>
> Dear Keith,

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

Thanks
Author
19 May 2009 2:30 PM
Keith Wilby
"Olivier" <Oliv***@discussions.microsoft.com> wrote in message
news:7487A629-AAC5-48F8-87AE-4D983C4A6C32@microsoft.com...
>
>
>
> Thank you for your reply but how will I achieve that?
>

Right-click the mdb file in an explorer window and choose "Security".
Author
20 May 2009 11:07 AM
Douglas J. Steele
"Keith Wilby" <h***@there.com> wrote in message
news:4a12be01$1_1@glkas0286.greenlnk.net...
> "Olivier" <Oliv***@discussions.microsoft.com> wrote in message
> news:7487A629-AAC5-48F8-87AE-4D983C4A6C32@microsoft.com...
>>
>>
>>
>> Thank you for your reply but how will I achieve that?
>>
>
> 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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
Author
20 May 2009 1:40 PM
Chris O'C via AccessMonster.com
I think Keith means file level security, not Jet (Access) security.

Chris


Douglas J. Steele wrote:
Show quoteHide quote
>>> Thank you for your reply but how will I achieve that?
>>
>> 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.
>

Author
20 May 2009 1:39 PM
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


Keith Wilby wrote:
>> Thank you for your reply but how will I achieve that?
>
>Right-click the mdb file in an explorer window and choose "Security".

Author
20 May 2009 2:30 PM
Keith Wilby
"Chris O'C via AccessMonster.com" <u29189@uwe> wrote in message
news:965ca96aca6d5@uwe...
>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.