RE: Link to a RW database from a RO database?
- From: '69 Camaro <ForwardZERO_SPAM.To.69Camaro@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Sat, 27 May 2006 17:02:02 -0700
Hi, Leif.
Actually I don't know if it makes a difference, but the directory will be
made read only for certain users. I'll still have full read/write access.
It matters -- if you intend to have the database file open concurrently.
It's better to give restricted users "Full control" permissions, but ensure
that they only open the Access database file with a shortcut that includes
the /ro command-line switch.
could I make the database file itself read-only (for certain users
only) inside the read/write directory? We are using Windows NT servers.
Yes, but the problem with this is that when the file is compacted, depending
upon the user's operating system and the version of Access used, the file
could get a totally new set of file permissions, because it's a brand new
file created in that directory as a result of the compaction. And even if
you had the correct combination of operating system and Access version,
there's no guarantee that the next OS or version of Access -- or patch --
installed on any of the users' computers is going to allow you to continue to
dodge the bullet.
For a list of the methods to use when there are restricted users (and a list
of what happens when you don't use a correct method), please see the
following Web page for a link to the article, "Multiuser Databases":
http://www.Access.QBuilt.com/html/Articles.html
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
"Leif" wrote:
Actually I don't know if it makes a difference, but the directory will be.
made read only for certain users. I'll still have full read/write access.
If I wanted to use Access security I would need to make the directory
read/write to allow for the lock file creation and deletion, right? In that
case, could I make the database file itself read-only (for certain users
only) inside the read/write directory? We are using Windows NT servers.
Thanks.
"'69 Camaro" wrote:
Hi, Leif.
Does Access allow you to write to a linked table from a read-only database?
Yes. Just make sure that the table link is created before the file is made
read-only.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
"Leif" wrote:
For security purposes I would like to create an Access database in a
directory defined as read-only for a certain class of users. However, I need
to programmatically record their access to the database when they open the
database.
I was thinking a possible solution is to provide a table link to another
access database for which they have read/write access. When they log in my
autoexec routine could write out some information to this second database
that is read/write.
Does Access allow you to write to a linked table from a read-only database?
Regards,
Leif
- Prev by Date: Re: stolen ownership, round 2, isnt this illegal?
- Next by Date: Re: stolen ownership, round 2, isnt this illegal?
- Previous by thread: Re: details
- Next by thread: Re: userid on network recording on record in a table
- Index(es):
Relevant Pages
|
