Showing the database window

[JJ]

How do you shoe the database window after a form is open. I have a user
login screen and normally it would show the switchboard. On the backend
when the user logs in I want it to show the database window. I do not want
to change the startup properties that way not just anyone can get to it and
they must have a uerid and password. I have the shift key bypass turned
off. Any ideas.

 

[Allen Browne]

Unless you also disable Special Keys, just press F11.
If you left the Window menu in place, choose Unhide.

If you have everything disabled, you could program a special key combination
(AutoKeys macro) or click on something to run code to turn those things back
on again.

The best solution is to create MDE files for the users, with all the special
keys etc disabled, and leave the MDB front end file in s state that's ready
for development.

 

[JJ]

How would I create an mde file with a backend database attached. The reason
for the backend is so I can backup (or FileCopy) the database while the user
is in it.

 

[Allen Browne]

You need to be able to alter the path to the back end?

See the example in solutions.mdb, downloadable from:
http://msdn.microsoft.com/library/officedev/bapp2000/mdbdownload.htm

It illustrates how to check the back end is available on startup, and if
not, offer the File Open dialog so the user can locate it.