Access 2007 startup with form only

[seatech1]

Does anyone know how to start Access 2007 with just a form, and none of the rest of the access window (like the toolbars, menus, etc)?
I know that you can go to the Access Options>Current Database and select a form to start with, but this is NOT what I'm looking for.
I've posted in other forums, and even though I specify that this answer is inadequate, people keep responding with it. So please understand that this is not the answer I'm looking for.
I'm looking for the way to open Access 2007 with ONLY a form of my choosing. No other Access window stuff like the toolbars, etc.
Anyone know?
Thanks.

 

[valgore]

well for that, you would have to make a stand alone application.

valgore

 

[seatech1]

Thanks, Valgore for your response and the other one. Are you saying that Access 2007 eliminated the ability to do this? That's incredible.

 

[valgore]

well, so your asking if you can open a database without a stand alone app and have no interface and just the forms/tables? i have never seen a way to do that. and it would be very hard to nagivate through the tables/forms without putting buttons that open individual tables/form

Valgore

 

[seatech1]

I am not saying it correctly, I guess. Sorry. In Access 2003, I could open a database with just a form, which was a menu, made in the switchboard (although it's not necessary to use switchboard). The main menu had just a few buttons on it, and would allow a user to go to the input/edit forms (or whatever) and just enter their data, or do some simple functions that I had set up, like reports.
The point is, there was no Access toolbar (ribbon, buttons, etc) at the top of the screen. All that the user could see was the menu or forms I wanted them to see and use. In 2007, I can't figure out how to do that. I don't want the user to be able to view tables, etc. Just the forms that I want them to use.

 

[valgore]

there is a help topic in Access.

Can I open an Access 2007 database in runtime mode without using the Access 2007 Runtime software?
You can run any Access 2007 database in runtime mode on a computer that has the full version of Access 2007 installed. To run an Access 2007 database in runtime mode, do one of the following:

Change the file name extension of the database file from .accdb to .accdr. 
Create a shortcut to the database, and include the /Runtime command-line switch in the shortcut.

this looks like what you want. just type in run-time in Access help and its like the second one down. right above this section it tells you what is disabled in run-time

The following Access 2007 features are not available in runtime mode:

Navigation Pane 
 The Navigation Pane is not available in  runtime mode. This helps prevent users from accessing arbitrary objects in your database application. Only those objects that you expose to users — for example, by providing a switchboard form — can be opened while using runtime mode. You cannot make the Navigation Pane available in runtime mode. 
The Ribbon  
By default, the Ribbon is not available in runtime mode. This helps prevent users from creating or modifying database objects, and from performing other potentially harmful actions, such as connecting to new data sources or exporting data in ways that you do not intend. You can create a custom Ribbon, and then associate that Ribbon with a form or report. You cannot expose the default Ribbon tabs in runtime mode. 
Design view and Layout view
  Design view and Layout view are not available for any database objects in runtime mode. This helps prevent users from modifying the design of objects in your database application. You cannot enable Design view or Layout view in runtime mode. 
Help
  By default, integrated Help is not available in runtime mode. Because you control what functionality is available in your runtime mode application, some of the standard integrated Access 2007 Help may be irrelevant to people who use your application, and could potentially confuse or frustrate them. If you are using the Access 2007 Developer Extensions to package and deploy your database application, you can provide a custom Help file with your runtime mode application.

Hope this help

Valgore

 

[seatech1]

Thanks,
I'll look into it and try it.

 

[randy700]

I don't have Access 2007 loaded, but in 2003 the option you're looking for is Startup. Perhaps if you search the help files for Startup or Allow Full Menus .....


Randy

 

[seatech1]

Valgore-
Your advice about runtime mode did the trick. And it's so easy. Just change the file extension from accdb to accdr, and it's done! I was amazed. Thanks for your valuable help.

 

[valgore]

Anytime.

If you have anymore trouble, let me know.

Valgore