Software

Change Access 2007 database options for your application

Make your Access 2007 databases more descriptive with custom titles in the title bar. Here's how to change database options in Access 2007.

Before putting your Access 2007 application into production, you should make some changes to what appears in the Access window. For example, instead of displaying PersonnelDB in the title bar, you may want to change it to Employee Records. Also, you may want the correct form to display when users open the application. If users only work with this one form, you may want to hide the navigation pane, which will prevent them from making any changes to the forms design or layout. Follow these steps:

  1. Click the Office button.
  2. Click the Access Options button.
  3. In the left pane, click Current Database.
  4. Click in the Application Title text box and enter Employee Records.
  5. Click the Display Form drop-down list and select the form you want to display on startup.
  6. Clear the Enable Layout View for this database check box.
  7. Clear Enable Design Changes for tables in Datasheet View for this database) check box.
  8. Clear the Display Navigation Pane check box.
  9. Click OK.

You will need to close and reopen the database for the changes to take effect.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

6 comments
jugjug
jugjug

Hi, I did use the access options with a database. The problem is that I cannot again use my database in the normal mode, that is, to disable the options that I have previously ticked/unticked in Access Options. Can anybody help? Thanks Jrishi

trschaefer
trschaefer

OK I understand the need to restrict editing in Access when distributing an Access Solution. But now, how to I get to the editing options, after disabling the editing options?

jhecker
jhecker

The first thing to try is to hold the Shift Key when you open the database. Hold it down until the database opens. This should bypass the Startup Options. I usually deply accde files to users. I also keep a working copy of all applications. I add the word "Working" in front of the application name. When I am ready to deploy, I make a copy of the "working" database, change the name to remove the word "working". I then open the renamed copy and apply the appropriate options and deploy that version. That way, I always have a version without the options set. I also use a custom "function" that locks the application down and if I don't do the dual version approach, I have severe problems. I hope this helps. John

A.K.Patel
A.K.Patel

I am preparing program for Tissue Culture Lab. I need to disable edit option. So,please guide me.

lukemh
lukemh

hold down shift key when opening database.

mike
mike

i would be interested in any info you could give re the locking down of a database I have one that I need to lock down before distributing it Mike