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

  • Thread starter Thread starter Henry Jia
  • Start date Start date
H

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!
 
Get the Security FAQ. All the information you need is there. There is a link
to it on the Security page of my website.
 
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.
 
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."
 
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
 
Back
Top