Software

Ask something
Question Locked

Problems with folder sharing and security

0 helpful
3 replies

by acqanal

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have an Access database application where I placed the data tables in a shared folder on computer-A and the Forms in a folder on computer-B. When a user who does not have admin priviliges logs on Computer-B using their profile and password, then launch the database from a shortcut, they receive a message stating that "The Microsoft Jet database cannot open the file or its its already in use exclusively by another user, or you need permission to view its data". No on else was using the database at the time, and the permissions on the shared folder seems to be okay. The strange thing is the database works for someone with Admin priviliges. Please help, I'm stumped.

3 replies

by menzo

Hi !

Did you set the permissions on the Security TAB too or just on the Share Tab ?

You should give Full Controll on the Share TAB and set permission on the Security TAB.

It should fix your problem.

by acqanal

Hi Menzo,
Thanks for your reply. I did set the permissons on the Shared tab to "Everyone" with full control, then add the various users on the Security tab, giving them Read/write privileges. But the problem still existed.

Here is another strange thing I discovered. If I make a copy of .mdb file which contains the Forms etc. and place it on the user's hard drive and not open it, the user can launch the database successfully. But once I logon to that user's workstation with my personal username and password, then open the database it gets screwed! The user can no longer open it! It seems my admin priviliges is locking the .mdb file. Could there be some hidden default lock settings in the setup of my Access 2000?

I checked the 'Options' of my Access software and the 'Default Record Locking' is set at 'No Locks'.

This discussion is closed to new replies.