Access Security

[abhoan]

Looking at the security process of ms access it seems easy enough to impliment, but as an novice user, I have felt really miserable with it all. Sometimes it ends up that the security.mdm file just dissapears and sometimes my users created are no where to be seen. Please help, i'd really be thankful if someone can put forward the exact procedure of setting up users and permissions in the database.

Thanks

 

[The_Doc_Man]

Before we give you a long dissertation, try searching this forum. The Search tool is great and the topic is a common one. Try searching for any of these key words and phrases

Workgroup, Workgroup Security, Security, Securing a Database

 

[abhoan]

will do that.. thx..

 

[abhoan]

ok.. doc.. back again.. i have found an appropriate tutorial, but some queries. i am trying to create a new workgroup file, but when i exit "WRKGADM.EXE" and restart access, the file is not being accepted.. how do i set the new file as default?

 

[abhoan]

another problem,
in the wizard after moving on with creation of groups amd creation of users, the error says "Object variable or With Block variable not set"...

 

[boblarson]

another problem,
in the wizard after moving on with creation of groups amd creation of users, the error says "Object variable or With Block variable not set"...

I can answer that one. You probably have some unfinished, or incorrect code somewhere and when it tries to compile it can't. Try going to the VBA window and go up to DEBUG and then COMPILE and if there are errors, it will take you to them.

 

[abhoan]

i did end up getting that myself too, but i didn't write any code.. its just a few tables and some forms.. there is no coding by me.. i haven't even got there yet..

 

[Len Boorman]

If you are trying to implement security literally just be using the wizard then you will probably have a problem.

It is a minefield for the unwary. I have acouple ofdocuments that explain a lot. They are too big to post here. Send me a PM with an email address and I will send them to you.

They make a good read

L

 

[The_Doc_Man]

but when i exit "WRKGADM.EXE" and restart access, the file is not being accepted.. how do i set the new file as default?

How do you know the new file wasn't accepted?

See, the workgroup is a REGISTRY function, and most of those are not visible to a user. So when you say "not accepted" - how do you know?

 

[Angeluz]

Well, Mr Boorman , i would be glad if i have one copy of the instructions.
Thank You so very much.
Please mail to me at hahnzz@yahoo.com.

Thanks.

 

[abhoan]

Same Problem Exists

The problem still holds. I have gone through the documantation and the error it seems lies in the VBA code. But i haveing no VBA code in my DB, seem to be in no state of working on the code to resolve the problem. Hence I have written a word document clearly explaining the problem, how can i post it to you?

 

[abhoan]

And about the new workgroup file works, was accepted, only that i couldn't see the name and name of the company being displayed. That was the problem, its solved now..

 

[abhoan]

Another useful site, "databsedev.co.uk". It has a section on security of a DB in 12 steps, explained intricately.