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
Are all your drivers up to date? click for free checkup

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.

Bookmark and Share