Re: Can I make Linked Table Read-Only
- From: Klatuu <Klatuu@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 12 Sep 2006 08:39:03 -0700
That is correct, but it is not as bacwards as it appears. When you open an
mdb, it tries to create an ldb file with the same name. If you have read
permissions, you can open the mdb, but if you don't have write permissions,
you can't create the ldb. As previously stated, without an ldb, an mdb is
opened as exclusive.
You can see your permissions in the Properties dialog of the folder in
question. (Right Click on it and select Properties).
I understand your concern about using another department's folder. Assuming
this folder only contains the other department's mdb, there is a way to
accomplish this provided IT will allow write permissions. That would be to
implement Access User Security. You could set it up so that users would have
read only permission on the table your combo is based on.
The only other option I can think of is to periodically import that table
into your mdb.
"Dj" wrote:
I'm sorry I'm not seeming to grasp this but it seems a little backwards to.
me. Please let me know if I have this correct...
If I don't have read/write access permission to their folder, I can open
their file in their folder and it will be locked for editing by them because
I've opend it exclusively. (.ldb will not exist)
If I do have read/write access permission to their folder, I can open their
file and they'll still be able to get in at the same time I'm in. (.ldb will
exist)
Is that correct? And is there a way for me to determine if I have
read/write access to their folder by looking at my properties on the folder
or do I have to ask IT. Also, it's not just me, but 15 users in my
department and I'd rather not ask IT to grant all 15 of my users read/write
permission to the other departments folder if I don't have to. Might there
be another way around this?
"Klatuu" wrote:
That means you need to get your network administrator to grant you read/write
permission to the folder where that mdb is located.
"Dj" wrote:
Ok, I just checked and this is what happens. When I'm in my DB, there is NO
.LDB file, however, the others still get a "file is in use" error and can not
get into thier DB.
If they get in their DB first, then there IS an .LDB file and my DB won't
let me access my combo-box; I get the same "file in use" error.
"Rick Brandt" wrote:
Dj wrote:
My db has a link to another's db which is only used to display a
combo box list that I choose a name from. When I'm in my db choosing
my name, apparently, that locks my co-worker out of his db that I'm
linked to. Can I set my db link to be a read-only so that my
co-worker will always have full access to his db even if I'm
currently linking it? Thx, Dj
Sounds like you don't have adequate permissions to the FOLDER where the
linked table file is located. When you make use of a link you are actually
opening that other MDB file and Access will try to create a locking file
(LDB). If you do not have permissions to create files in that folder then
no LDB file is created thus giving you exclusive access to the file.
To test, look at the folder where the other file is located and then open
the form that has your ComboBox on it. You should see an LDB file appear in
that folder. If not then that is the problem.
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
- References:
- Re: Can I make Linked Table Read-Only
- From: Rick Brandt
- Re: Can I make Linked Table Read-Only
- Prev by Date: Re: Can I make Linked Table Read-Only
- Next by Date: Re: Can I make Linked Table Read-Only
- Previous by thread: Re: Can I make Linked Table Read-Only
- Next by thread: Re: Can I make Linked Table Read-Only
- Index(es):
Relevant Pages
|
|
