User Level Security

[heller]

Hi guys,
I have a serious problem in securing a access 2002 database with the user level security wizard.
The file is located on a server. If I follow my 40 bucks access book, I can secure the database and give different rights to different users.

Problem one:
What is all that administrator talk? The book says as administrator i don't even have to use a password. If I want to access that secured program from my computer, it asks me for a password. So how can I become administrator?

Problem two ( the real one):
So I have secured that file which lies on the server. If I open it, it asks me for a password. Well, if I access it from another computer, it just opens without asking for a password?!?!?!?!?!?!?!?! That's not really how it is supposed to be.
By playin g with different options in the security, I just reach, that no one else can open it. This is pretty much as bad as everybody can open it.

So if someone could give me some hints how to solve that, i would be very glad.

Thanks,

Heller

 

[The_Doc_Man]

First, search this forum for "workgroup security" - if you don't get fifty to a hundred threads, I'll be surprised. Also try just "workgroups" and "securing a database" and other topics like that.

OK, here is the key to understanding workgroup security. When you secure a database, you use a workgroup file to hold the security info. But the pointer to that workgroup is in your registry. If you wish to use the data in the workgroup file, you have to join the workgroup, which updates the registry. Each machine has its own registry. Joining a workgroup on machine A has no effect on machine B.

By default, a workgroup file exists, called system.mdw, on ALL systems that have MS Access installed. By default, you are automatically the administrator in that workgroup and your password is blank. If you join another workgroup, that situation could change. But what you describe is simply that the "other" computer's registry hasn't been updated by the act of joining the workgroup.

I'm not going to re-invent the wheel here. I'm serious that you should search the forum. I've posted over a dozen explanations myself on this exact topic, including detailed instructions on how to make this work better for other users who don't join workgroups either. I would prefer not to repeat it all again in this thread.

 

[Shane_1]

Ok, here is the thing:

1. I have searched the forums.

2. All I get is you telling people to search the forums........

I am having the same problem, if someone could put it in laman's terms I think we would both be happy people. or maybe make a tutorial on it and make it a sticky and point people to it when they ask for security advice.......

I have went throught 20 threads and still no answer.......

 

[GrahamUK33]

Checkout this thread, it could sort out your problem. http://www.access-programmers.co.uk/forums/showthread.php?t=64532

Hope that hellps