How to programming to apply User-Level Security to a mdb file

[Henry Jia]

I have a system database (mdw) file and a normal mdb file. Now I need use
code to make the mdb file apply User-Level Security. What should I do?

Thanks in advance!

 

[Lynn Trapp]

Get the Security FAQ. All the information you need is there. There is a link
to it on the Security page of my website.

 

[Henry Jia]

Thanks. I read this article before but it can't help with my question.
Now let me give more detail description about the question:

1. I have a system database (mdw) file and users already added;
2. I have a normal database (mdb) file and want apply user-lever security on
it;
3. It should be achieved using code;
4. The mdb should can't open directly when a different system database was
used and will get a permission denied messagebox just like I explicit use
security wizard.

That's all.

 

[Lynn Trapp]

I'm not sure why you say "it can't help with your question." Section 37 of
that article gives you the code necessary to "use DAO to manipulate
permissions."

 

[Henry Jia]

Thank you for the reply.

I knew that I can modify the permission of objects in database, but how
about database itself. I need the mdb file can't be opened directly but get
a message tells something like permission denied - just same as the one been
processed with User-Lever Security Wizard.

Hope you can help and thanks!

Henry