New to Access Security - can only work on my machine

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I recently set the user security levels in an access database for the first
time. Since I had never done it before I used the wizard. The database is
stored on a shared drive so that all 4 users can access it. One of the other
users has been given administrator rights and as long as she logs in from my
computer everything is fine. When she logs in from hers (or when I log into
it from hers) it says it is read only. I know that you all have probably
heard this question a hundred times but I didn't see a response about it and
am getting desperate since she is supposed to be taking over my duties when I
move offices shortly. Please advise me on how to correct this. I even tried
to figure out how to turn it off but I can't seem to do that either.
 
sondraspalding said:
Hello,

I recently set the user security levels in an access database for the
first time. Since I had never done it before I used the wizard.
Click to expand...

What version of Access?
The
database is stored on a shared drive so that all 4 users can access
it. One of the other users has been given administrator rights and as
long as she logs in from my computer everything is fine. When she
logs in from hers (or when I log into it from hers) it says it is
read only.
Click to expand...

What is the exact error message? Is the 'shared drive' on a server or is
this peer-to-peer and it's on your computer?

All users will need read/write/create/delete permissions on the folder where
the mdb is located.
 
Thanks Joan. I think I finally got it working. And it was really kind of
stupid but like I said I am new to security in Access. I went over and made a
shortcut to the .mdw file on her desktop and now it appears to be working. It
didn't even occur to me that I would need to do that. Sorry for taking your
time but thank you for your assistance.
 
Back
Top