permissions

[samjesse]

Hi
Using Access 2000 under windows XP pro. computers in a LAN, I have a split database on machine1 with the back_end file located in the Shared Documents folder "C:\Documents and Settings\All Users\Documents" and a front_end located in another folder.
Machine2 has a copy of the front_end but when I run it I get a massage saying that the back_end file is open exclusively by another used or a permission is needed to view its data.
No one else used our computers except us and I do not really want to secure the database however we all use any of the machines with User privilege to the machines OSs.

How can I get user2 in machine2 to be able to use the database?

Many thx

 

[apr pillai]

If machine1 and machne2 are client machines of LAN then best option is to install the back-end database on a common folder in LAN, accessible to both parties.

If that is not possible then you may try peer-to-peer mapping of the shared folder of machine1 as a network drive on machine2.

If that is already done then check the table link references refers to the correct machine. Refresh the table links to the correct location.

Instead of using the mapped drive name (H: or T: etc.) use the UNC type address: \\ComputerName\FolderName\SubFolderName for linking the tables. This will take care of the mapped drive, if changed to a different drive letter in future.

If all these things are in order then make sure that MSAccess is not running either in machine1 or machine2.

Inspect the back-end database file folder that a file with database name and with file extension .ldb is present in there. This can happen if MS-Access is not shut down properly during last session, due to power failure etc. This file is created automatically by MS-Access and stores some information in it (check this link for details) and removes it during normal shutdown.

If this .ldb file is intact in the back-end database folder then you may get the message you have reported in your post.

 

[samjesse]

apr pillai

The first "best" option.
Aren't the machines clients of the LAN in my case? if so, Isn't Shared Documents folder "C:\Documents and Settings\All Users\Documents" a common folder in LAN? (btw, it is accessible to both machines).
What do you mean by install the back-end database? Do you mean copy and paste the .mdb file?

Best

 

[apr pillai]

The LAN machine will have a name (like IBMLAN or whatever name given to the machine) and is addressable with it's name and folder name Like \\IBMLAN\FolderName rather than C:\User\My Documents\Document etc.

The folder name part will have several folders like Audit, Accounts, Hrd etc. intended for different user-groups and each folder/SubFolder is assigned with permissions so that each of them is accessible only to their respective user-group.

If you are able to open the back-end database at any point of time check the following:

Go to Tools Menu, Advanced Tab and check to ensure that the Shared option radio button is in selected state. If I am not mistaken the Exclusive option is in selected state now.

 

[apr pillai]

Go to Tools Menu, Advanced Tab and check to ensure that the Shared option radio button is in selected state. If I am not mistaken the Exclusive option is in selected state now.

Go to Tools Menu, Options, Advanced Tab and check to ensure that the Shared option radio button is in selected state. If I am not mistaken then the Exclusive option is in selected state now.