Current User Settings

[JK]

In my database I configure usernames and passwords for those people that need
access. On my main menu I display the current user and that person security
setting.

My worst fear just came true; and yes, I'm obviously an Access Rookie - in a
multi-user enviornment, I'm running into problems. With more than one person
connected, the system doesn't know who each user is.

Would anyone out there be able to point me in the right direction? I need a
way to track the connected user (each connected user) even if there are
multiple users connected.

I thought maybe there is an example out there that would help me out?

Thanks!

 

[Daniel Pineault]

Is your db split?
Did you implement User-Level Security?
How are you determining who the current user is?

Have you taken a look at

http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

 

[Linq Adams via AccessMonster.com]

If it's a multi-user environment it's got to be split into frontend/backend,
with each user having their own frontend on their PC! Handle the
username/password part in the frontend.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Klatuu]

Rolling your own security requires a competent Access developer about 5
minutes to crack it. Using Workgroup security improves the security a little.
And as previously stated, you need to use a split database with each user
having their own copy.

 

[JK]

First of all, am I the only one having trouble with this website? It does all
kinds of weird things...

Anyway, about my database-

Yes, it's split. I've disabled the shift key and I've created all new form,
report menus so that the user cannot get into design view.

After splitting my database I created an MDE file. Then, I tried copying the
mde file to each desktop - this obviously does not work.

Now, I guess I'll try creating a separate front end file for each user and a
separate mde file for each user based on those front end files - hopefully
this works.

I tried playing around with the access workgroup security settings - but I
wasn't able to fully figure out how it all works. I'm also not certain that
would solve my problem anyway...

Am I on the right track?