|
| |
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
 |
Security - for different user to open - 12/8/2005 14:35:57
Hi,
I am MS Access Beginner. I have a security problem.
Suppose there are 5 computers, there is a drive m:\ which is sharing drive, 5 computers can access the drive m:\.
I made a acc.mdb file in the drive m:\
Then,
I setup a Security with different username on my computer,
then it automatically creates 2 files: Account.bak, and Secured.mdw
I can open it on my computer, but when I used another person computer to open it.
Then it give out the message:
"You do not have the necessary permission,.........Have your system Administrator or the person who created this object establish the appropriate permission for you"
It does NOT show the prompt.
It should display the prompt first.
The file is sharing with 5 users. Why they cannot open it?
Please let me know how to solve that.
Thanks a lot. Thanks.
|
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Security - for different user to open - 12/8/2005 14:59:35
Ensure that each user has all of these priviledges:
read, write, create, and delete
for the entire directory. They need those to be able to deal with the necessary .ldb file.
That help any?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
|
RE: Security - for different user to open - 12/8/2005 15:13:34
what is the .Idb file?
Do I need to put .Idb file in the sharing drive m:\
if so, where can I find the .idb file?
Please let me know, thanks.
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Security - for different user to open - 12/8/2005 15:23:05
It's actually .LDB file and you don't create it but Access creates it automagically when someone opens the file using Access. It tracks record locking and stuff.
If each user accessing the file does not have all of the priv's listed above, the .LDB file will not function properly (if at all) and is required to use Access in your situation.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
|
RE: Security - for different user to open - 12/8/2005 16:07:17
.ldb file cannot automatically created.
It automatically creates .mdw and bak files only.
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Security - for different user to open - 12/8/2005 16:09:40
quote:
.ldb file cannot automatically created.
What version of Access are you using? Same issues. Access absolutely needs to be able to read,write,create, and delete a file to track the record locking.
Have you confirmed those priviledges for all users?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
|
RE: Security - for different user to open - 12/8/2005 17:45:44
How to do that?
I am fixing this problem for a long time, still don't get.
Because there are a few computers, and the computers have one sharing drive m:\, every user can access this drive and open the files.
I made the MS Access file in the drive m:\, and setup user-level security with different users, and also assign some permission to the users (I am Administrator).
After done that, my computer works very well, but the users cannot open the file on their computers, when they click the file, the file does NOT show the prompt, and give out the message, "...............Have your system Administrator ................"
I put the .mdb , mdw, .bak files in the drive m:\,
why they cannot access the file?
I am using 2002 MS Access.
And also, once I setup the Security for one file, then it will affect other files, because I only setup one file with user-level security, but when I open another file without security, it still show the prompt to log in.
It make me so trouble, right now.
Please let me know how to do.
Thanks.
Thanks.
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Security - for different user to open - 12/8/2005 18:02:28
quote:
have one sharing drive m:\,
You have to set the priv's in the folder that contains the db file (presumably that m drive) and not just the database file. We need more than just read privs. You have to do this at the machine that is sharing and not from a logged in worksatation.
I'm unsure as to how else to explain it so I'll try one more way: set the priviledges on the folder (or directory) that the Access file is in to those priviledges. I am absolutely certain you cannot use the file the way you intend without those priviledges and I have not seen any indication that you have checked this.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
|
RE: Security - for different user to open - 12/8/2005 18:27:30
I think that I need to go every user 's machine, and then join the group "Secured.mdw" file.
I am not sure, but I will try it.
Thanks.
| |
|
|
|
accessman
Posts: 74
Joined: 9/13/2005
Status: offline
|
RE: Security - for different user to open - 12/8/2005 18:43:28
Hi,
I did that, yes, I successfully to do that.
I must go to the user's machine, and then join the Secured.mdw file.
But, I got another problem, this security affect other files,
because I only setup security for one file, but it affect other files. When I open other files, they need password and username. But, I am sure I do NOT setup security with that files.
How do I fix that? I just want to specify one file with security.
Thanks.
| |
|
|
|
rdouglass
Posts: 9280
From: Biddeford, ME USA
Status: offline
|
RE: Security - for different user to open - 12/8/2005 20:08:48
quote:
How do I fix that? I just want to specify one file with security.
If you must keep the containing directory anonymous to get rid of the login, how about a sub directory? Better yet, how about a mapped drive? To me, that's the simplest solution.
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
