I have just built a Access 2000 database for a local charity I volunteering for, and am wanting to make it a stand lone application. Being a little rusty with my Access skills I was wondering if somebody could advise me how I can make my control form start straight up and hide table definitions etc. from the user? By doing this I also want to limit the menu functions when the database is run.

I know these things are possible, but I cannot remember how to do it. I would appreciate somebody pointing me in the right direction. I have tried doing a search using the Access help but can' t find what I am looking for.

Gaz

__________________
Gaz

Open the 'Tools' menu, 'Startup' and you can set things like start up form and there are a number of tool bar options that meet many of your basic needs. You can also name a macro 'autoexec' and have it run (RunCode) a function procedure that opens one or more forms and allows/disallows toolbars depending on which user is opening the application or the name of the computer on which it is run. For example, I have a procedure that returns the NT login (not shown below) that only allows me to use the built in toolbars:

If gUser <> "jurgenw" Then Application.SetOption "Built-In Toolbars Available", False


Ciao
Jürgen Welz
Edmonton AB Canada
[email protected]

If you want to massively limit your users - i.e. not let them do ANYTHING other than use your forms - set them all to maximize on load and set the border style to none.
Once you've done that, and you're sure your database works perfectly, you can set the "Shortcut Menu" property of all your forms to No

Steven

I am a loud man with a very large hat. This means I am in charge

You can also give then an MDE, a compiled form of DB under Tools|Databsse Utilities. Make sure you keep an uncompiled version for yourself:)

--

Joe

Thanks for all your help it's most useful. My knowledge is flooding back lol. What I was also trying to ask is how I can limit the functions on the Access menu bar when the database is run?

Gaz

You could create your own menu bars, and hide all the others

I am a loud man with a very large hat. This means I am in charge