Opening Database in Form View Only

[rsgriffith]

I have created several forms that are populating their respective tables. I have created a main-form with command-buttons that are linked to each of the individual forms used for table populating.

What I would like to do is when a User opens the database it opens straight into the main-form page...from there the User can choose from the multiple buttons which are linked to the various individual forms.

This would also keep the User from seeing the actual tables and forms in Access, which leads me to my next question.

If the above can be setup to open into the main-form how can I actually set it up so the User has no access to actually edit the forms or tables.

thanks in advance
RSG

 

[jeremie_ingram]

When you have the databse open, left click on TOOLS on the toolbar. From the tools menu select STARTUP. This will open the startup dialog box, from which you can set the options you are looking for. The upper right Display Form/Page will allow you to select the form you want to show on open, and directly beneath that you can disable the Database window by unchecking that option.
By turning off that option you can still access the database window by pressing the F11 key, but you can disable that by unchecking the USE ACCESS SPECIAL KEYS in the lower left corner of the STARTUP dialog window.

NOTE: MAKE A BACKUP COPY OF YOUR DATABASE BEFORE YOU EVER MAKE THESE KINDs OF ALTERATIONS.

 

[rsgriffith]

Jeremie

Thanks for the quick reply, just one question:

If I disable the "USE ACCESS SPECIAL KEYS" to eliminate the use of the F11 key which I'm assuming anyone can use to actually get into the edit mode then how will I myself be able to get back to the eidt mode???


RSG

 

[jeremie_ingram]

You should still be able to hold shift key while opening the database to get to the database window. To lock it down even tighter, you could use the database tools to create a MDE file from the database. Go to help and type in MDE and see if it is what you are looking for.

Saving your Access database as an MDE file prevents the following actions:

Viewing, modifying, or creating forms, reports, or modules in Design view.
Adding, deleting, or changing references to object libraries or databases.
Changing code — an MDE file contains no source code.
Importing or exporting forms, reports, or modules. However, tables, queries, data access pages, and macros can be imported from or exported to non-MDE databases.

 

[rsgriffith]

Thanks- Opening in Form View

Jeremie, I appreciate the advice...will check out the mde info

thanks
Ralph