Access Privileges for Linked tables

[gohard]

Hi,

I am currently working with an access database, that I had nothing to do with via development or otherwise
but... it seems that if they are a legacy user, there are no issues, however if I add a new user via active directory and attempt to relink the database, it gives me an error, regarding the fact that it could not lock the table in order to relink it. Is this a permissions issue or a setting in the options of Access? Help

 

[CautionMP]

gohard,
[ol][li]Access wants exclusive access to the table to do the linking (this would be the first I've heard of this happeneing) so you will need to 'kick' all other users out of the database before you can link.[/li]
[li]The new Active Directory user does not have permission to create new files in the directory the DB resides in. If there is no one else in the database Access will need to create a 'locking' file (*.ldb) in the directory the database resides in before the user can change the data.[/li][/ol]

Hope this helps,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[gohard]

ok... so...
I tried to link while other users were not using it.
Worked.
Now that other users are accessing it, it comes up with an error for the one user that it can't lock the file, as it is in use.
I am not an access guy, but not dumb either, ok a little bit...
where do i turn off the locking or rather need to lock option...
and should the ldb, reside on the location of the database (shared network drive) as I noticed that it did create it's own .ldb file from where I clicked on the database... make sense?

 

[CautionMP]

gohard,
There is a Access setting that may be causing the issue. Do the following and make sure that the default open mode is not set to Exclusive.
[ul][li]Tools -> Options...[/li]
[li]Advance (tab)[/li]
[li]Default open mode: Shared (not Exclusive)[/li][/ul]

And as always, remind the user that them buttons is not for der' finger pokin'

CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)