registering users of an access database

[Alylia]

I have almost completed an access database for my office which is going to be
used via the LAN.

In this regard, i am looking for assistance on how to get all users to use a
password to log into the database and also to register all such log-ins for
system audit.

By the way I am using Ms Access 2002

Thx

 

[aatcbbtccctc]

I have almost completed an access database for my office which is going to be
used via the LAN.

In this regard, i am looking for assistance on how to get all users to use a
password to log into the database and also to register all such log-ins for
system audit.

By the way I am using Ms Access 2002

Thx

Do you plan for the database to be used by several users simultaeously?
If so, have you split it into a so-called "front end/back end" (FE/BE)
structure? If not, you have quite a bit more work to do, before you
worry about adding user auditing!

HTH,
TC

 

[Alylia]

Hello,

Do you plan for the database to be used by several users simultaeously?

Answer - Yes

If so, have you split it into a so-called "front end/back end" (FE/BE)
structure?

Answer - I have done all of this, what I need now is what has to be done to
ensure proper system audit.

Alylia

 

[Lynn Trapp]

Check out the following website

http://www.rogersaccesslibrary.com/download3.asp?SampleName=AuditTrail2.mdb

 

[Keith Wilby]

In this regard, i am looking for assistance on how to get all users to
use a password to log into the database and also to register all such
log-ins for system audit.

You're ready, by the sound of it, to explore the delights of Access user-
level security. It is a complex subject and you should always work on a
copy of your files since it's easy to lock yourself out. Start here:

<http://support.microsoft.com/default.aspx?scid=/support/access/conte
nt%2fsecfaq.asp>

and there's a step-by-step example on my web site.

User auditing is reasonably straightforward, especially if your users have
their own named accounts within the user-level security. Check out the
'CurrentUser' function.

Good luck.
Keith.
www.keithwilby.com

 

[Alylia]

What I'm getting on clicking on the link to the site is "The requested web
page is not available"

 

[Keith Wilby]

What I'm getting on clicking on the link to the site is "The requested
web page is not available"

It might be a word wrap problem. Try copying the link into your browser
address box - be sure to get the entire string up to the '.asp' bit at the
end )

 

[Immanuel Sibero]

Alylia

Try this link:

http://support.microsoft.com/support/access/content/secfaq.asp

HTH,
Immanuel

 

[Immanuel Sibero]

Alylia,

I hit Enter too soon. Once you've read the MS Security FAQ a few times. Then
head on over to:

http://www.jmwild.com/Accesssecurity.htm


HTH,
Immanuel Sibero