Database window

[rabide]

Hi:
I want to turn the db window off in the startup options sot he users cannot access the tables. But I want only one user to access the window only after the correct password is entered in the form which will be hardcoded. So when the user enters the correct password in the form, the DB window should open up with all the tables and forms, etc. objects on it. Is it possible? This is for direct table maintenance (for e.g look up tables, etc.). Other users can update data in the tables but through forms only.

Thanks in advance. Any help will be greatly appreciated.

 

[CasperTFG]

Make a form called Password where they can enter the password for the DB. Set this as the start-up form and in the Properties you have to hide the Database Window. When they enter the password correctly then show the Database window.

But there is a fundamental problem with this. You see anyone can still access this database by doing the reverse of what you did to hide the window. Instead of doing this you should open the DB. Go to Tools, Security, Set database Password. This will make it so that no one is allowed to access the DB unless they enter a Password. Craig, mailto:sander@cogeco.ca

"Procrastination is the art of keeping up with yesterday."

I hope my post was helpful!!!

 

[Junior1544]

another possable solution is to lock down the database a little more... if you use user level security, then you can make it so that the typical users can't modify the the forms, query's, ect... and have the one user account that is allowed to do what ever you want them to... just make sure to maintain one user with full rights so that you'll be able to make your changes... (i have three just in case i change my password and forget it, or make a typo...)

hope this helps...

Junior1544@yahoo.com
Life is change. To deny change is to deny life.

 

[Guest_imported]

I like the "Access universal password": The SHIFT key. If you just hide the database window initially, and restrict any toolbars/menus, etc., using Tools|Startup... options, you can still get in to the database any time you want. Hold down the shift key while you start the database (however you're doing that), and keep it down until the database has opened totally. The startup options will have been ignored, and the database will be totally open.

I *just do not* know how this use of the "Access universal password" interacts with a database password as CraigSander mentioned. I doubt it gets around that, but don't know.

Here at work, I close everything, remove toolbars and stuff, make forms themselves very functional, and give the users only an .mde. I keep my .mdb files in a restricted folder well away from their .mde files. I leave the Tools|Startup... options always set, and I make a habit of holding down the SHIFT key while opening my files. (Otherwise, I'd have to deal with my own restrictions -- preish the thought!) Note that I also have to hold down the SHIFT key while I compact or repair my databases, too, if I want to be able to work on them when they re-open.

 

[ray00]

Thanks for the responses!
As Craig mentioned, we can open the dbwindow when the correct password is entered. But can you please let me know what the code is to open the db window? I tried docmd.opendbwindow, etc....Nothing works!

Thanks again.