Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

View Database Window

Status
Not open for further replies.

mswilson16

Programmer
Nov 20, 2001
243
US
I was trying to make my database as secure as possible. My main aim was to make it so that the database window could not been seen on opening or could not be enabled within in the database.

I managed to achieve my goal but now I need to be able to view the database window again. I was wondering is there a method of enabling the access special keys or enabling the database window within the current database or maybe from a different database?

I think that I will have to enable the window from a different database as there is no way I can get into the design of the current database.

Thanks in advance.
 
Have you tried "shifting into" the database? Hold down shift key while opening the database. (Of course, if your users know this trick then your database isn't as secure as you think it is.) Maq B-)
<insert witty signature here>
 
I disabled the shift key via vb. I have the vb to enable it again but the problem is I can not get into the design to make the change.

If anyone knows how to change the properties of a database from a different database then I think that will do the trick.
 
Ms, I think this FAQ will help you. faq181-1172

I wrote it to basically show a way to lock and unlock the database. The code will lock the database when a user goes into it and unlock it when you enter it.

You should be able to use parts of this code to accomplish your needs. Put the code in another database and instead of setting db = Currentdb(), set db = yourdatabase.

Good Luck. Maq B-)
<insert witty signature here>
 
Cheers for the info! I will keep you updated on the progress.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top