If your dB is on a network drive then you could use AD (Active directory) to give users permission to the folder/database. So only users who have these permissions will be allowed to open the dB.
Hi Terry, I found this code on: tek-tips.com faq181-93
If you are using a network where users login under a unique ID, you can capture that ID in MS Access. This FAQ provides the code necessary to capture the ID, validate users that open the database, and disable the shift key for bypassing the autoexec macro.
This only gives you a method of getting the current users logon (ID). You STILL must make use (code) of the users ID which is also stated in the link >>
"One good example of using the Login ID is to keep users out of a database using this ID. Create a table with the valid user id's and check the list using an AutoExec macro with the RunCode command. You will need to: - Disable the shift key by running the ap_DisableShift function in the debug window (see following Code) - Check the Login ID in a function (see following Code for ValidateUser) and kick the user out if it does not match."
So the answer I gave "Skrevet tir. d. 16. marts 2010 kl. 16:01:53| #1" is still correct
And if as you say, "the user has diff level of acces to the DB! " then even more code is needed.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.