Login på access database

No, unless you make your own login system.

http://www.eksperten.dk/guide/314

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, Yes it is on the network, to use AD is a problem since the user has diff level of acces to the DB! Thank any way :)

"since the user has diff level of acces to the DB!"

You can use Access own user/group security system but that still doesnt use Windows security.

You would need to make your own system which uses the Windows login but it requires some work to make it secure.

I suggest you read the link I gave

status please?

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.

I thing i will try this.

can you send me a direct link to that code please?

Here it is http://tek-tips.com/faqs.cfm?fid=93
:)

As I thought :o)

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.

status?