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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database Startup

Status
Not open for further replies.

Tezdread

Technical User
Oct 23, 2000
468
GB
Hi,

I've created a database, changed the startup options so that certain options aren't visable and I know that holding the left shift key when opening it will allow me to see the otherwise hidden objects / menus.

Is there anyway of changing the key options so that holding down the left shift key wont work and reassign it to another key?

Tezdread
"With every solution comes a new problem"
 
Start the .mdb with a tiny vb .exe stub.

Use the GetAsyncKeyState to see if they're opening the exe with the shift key down, if so, bail, otherwise do a simple Shell()to start the mdb.

Once you use this simple method, you can get very creative inside the vb stub--such as creating an Access.Application object and control everything from the vb application, but the simple solution is just to shell() and give control to MSAccess.exe.

Use a /wrkgrp option in the command line to start it with a secure .mdw so that that particular mdw MUST be used to even open the .mdb--this way they can't just find the .mdb and open it without the .exe. The .mdw need not be found either, I'll typically name it somthing.dll and hide it in winsys, and nobody's the wiser.
--Jim

 
If anyone is looking for a quick way to disable / enable the shift key, the shiftkeyv2000.zip file contains a database that allows you to select any db and with a click of a button you can disable / enable it...

thanks guys

Tezdread
"With every solution comes a new problem"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top