Don't want the MS Access Environment when running a database 1

[chrsab]

I am currently designing a MS Access database, with helpful information for users to be used over a network. A problem i am still looking to solve is that i want the Users computers to just show the relevant forms, without the MS Access environment in the background. I have been told that this is possible.....Is there anybody who can help me out?

 

[mrf1xa]

Go to Tools, startup. The option there enable you to stop the user seeing the database window and to specify which form to show when the database opens. This should give you what you want.

One tip- if you want to bypass anything set in startup, just hold down the shift key whilst opening your database and you will go straight to the database window.

Nigel

 

[oharab]

To completely hide the access environment and just have a form floating over everything else, look at the code here:

http://www.mvps.org/access/api/api0019.htm

WARNING: Make sure you build some code that closes Access when the form closes. Otherwise you will have access open, taking up system resources, but no way of closing it without resorting to the task manager.

Ben ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------