Shared Network Database User Permissions

[NathanBWF]

Newbie Help - Database shared on a network + user permissions EDIT: Fixed!

I've created a database in MS Access (Office 2000 Premium edition of Access) that I've put in a folder which is shared across the network on a Win XP Pro machine. 3 other people will need to have access to it as well as be able to add/modify data that is in the database. On the machine that it is shared on, I've created users for each person as well as myself (which I've givin admin rights to through Access), and givin them the ability to read/update/insert/delete data. When I open up the database on the computer that it is on, it asks for a username/pw and when you log in the appropriate permissions are assigned which is exactly how I want it. The problem is when accessing it from another computer on the network it immediately opens up as a read only file and doesn't even ask for a username and/or password. Is there a way for it to have the same security permissions as it does when accessing it from the local machine that it is on...? Anyone who can help out this newbie, it would be greatly appreciated....

EDIT: I got it fixed. post at bottom of thread.

 

[jfgambit]

You need to set the users security abilities on the folder that is being shared.

 

[NathanBWF]

You need to set the users security abilities on the folder that is being shared.

Are you talking about Windows based share permissions...? The users have full access to the shared folder...I double checked that.

 

[o1110010]

Have you double-checked to see if the shared folder has the appropriate users & permissions set? And made sure it propagates to all the other objects under the folder?

If that is no help, try messing around with the permissions of the account Everyone. See if the change is noticed from the other computers when someone accesses them.

Edit: Oops. Just read that you've double-checked the shared folder.. but how about the objects (files/sub folders)?

 

[NathanBWF]

Have you double-checked to see if the shared folder has the appropriate users & permissions set? And made sure it propagates to all the other objects under the folder?

If that is no help, try messing around with the permissions of the account Everyone. See if the change is noticed from the other computers when someone accesses them.

Edit: Oops. Just read that you've double-checked the shared folder.. but how about the objects (files/sub folders)?

Yes I'm certain the Windows share permissions are correct. I actually figured out my first problem but now have a new one. I didn't have the path pointed to the appropriate MDW file. I changed that and now when they try to access the database from accross the network they get prompted for a username/password which is good, but when I try to use a username/password that I created it says that it's 'incorrect or no such user'. I tried running the security wizard again but it says I can't because I've already done that and assigned a MDW file to that database. Is there any way of re-running the security wizard and/or creating a new MDW file for the database...?

 

[Pat Hartman]

it immediately opens up as a read only file and doesn't even ask for a username

This is two separate problems. The first is a permissions problem. When a database is opened (any database, not just ones that are specifically secured), Jet needs to create an .ldb file. This .ldb file is used to manage users and track updates. If the file cannot be created, Jet forces Access to open in read-only mode.

If you are not being prompted for a logon id, the db has not been properly secured. You have missed some critical step. Get the Security FAQ from the MS knowledgebase site. It contains the solution. I've attached a copy but there may be a newer one so do go look for it.

 

[NathanBWF]

Well I finally got it. Thank you Pat Hartman for that file. I read it through, then went through it step by step from scratch and low and behold it works now! Thanks to everyone for the help...I guess next time I should RTFM first eh...?