Question Password protecting the FE with a unique password for each user. Is it possible?

[CarysW]

As the title says.

I have not yet split my database, do I need to do this before I create the passwords?

Sorry if this is a completely obvious and easy thing to do!

 

[DCrake]

You need to either use ULS or create your own login screen for users. But I would split the database first in any case. Make a copy of it before you do so, so that you can rollback if needed.

David

 

[CarysW]

Thanks David. The tutorials I'm looking at are really confusing - any idea which would be the best 'plain english' tutorial to help me do this?

 

[DCrake]

To be honest I have never used ULS always relied on my own user management system. There will be other here that can point you in the right direction.

David

 

[Access2007User]

DCrake I can you kindly give me a vb6 example like Access gave northwind database sample for access.

A vb6 example which has objects data connections, forms, report, modules etc. so I can study it like I did with northwind. thanks.

 

[cdemuth]

I just set this up on a 2007 database. I set up an input form with unbound controls for user name and password. I also set up a hidden table with passwords listed. When the enter button on the input form is pressed it runs code that does a dlookup on the password table of the password entered based on the user name entered. If passwords match, it opens the main menu. If there's no match it pops up a message saying the entries are invalid. You also need to set this input form up as your startup form for this database. Let me know if this is what you were looking for and I'll post the code