Log In Question

[Guest]

I am not sure if I should post this question here or not. And it may be
something way over my head but I am going to ask any way.

Is there a way to create a log that requires a user name and password for
someone to access a database?

What I am looking at doing is having different people enter data into the
database, but based on their user name, I would have a different swithboard
manager window appear limiting their options.

Any suggestions?

 

[storrboy]

I am not sure if I should post this question here or not. And it may be
something way over my head but I am going to ask any way.

Is there a way to create a log that requires a user name and password for
someone to access a database?

What I am looking at doing is having different people enter data into the
database, but based on their user name, I would have a different swithboard
manager window appear limiting their options.

Any suggestions?

Are you intending to restrict access to objects in the database
(tables,queries,foms,etc.) or just see/permit who is doing what? If
you are not worried about securing things then it's pretty simple.
Otherwise, you enter a somewhat more complicated realm.

 

[Guest]

No I am not really worried about securing things. I don't think the users I
will have using the database will be the kind to go searching around to see
what they can find. So being able to let them see/permit forms for data
entry would be the best for me.

Hopefully, I am making sense.

 

[John W. Vinson]

I am not sure if I should post this question here or not. And it may be
something way over my head but I am going to ask any way.

Is there a way to create a log that requires a user name and password for
someone to access a database?

What I am looking at doing is having different people enter data into the
database, but based on their user name, I would have a different swithboard
manager window appear limiting their options.

Any suggestions?

You can implement Access Security and set the users' permissions to
allow them to see only specific forms or tables. Download the
Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Read it - CAREFULLY.

Back up your database, just in case: it's not hard to mess up
security.

Print out the FAQ and follow the steps in it, *rigorously*. I've
secured many databases and I still do so, checking off each step on
the printout as I do.

Programming the switchboard to detect CurrentUser() is an additional
step, but not a very difficult one.

John W. Vinson [MVP]