The Favorites Tab - Workbench Help File

	The Workbench for Microsoft® Access - Help guide
	Home \| Open \| Favs' \| Who's On \| Compact \| Backups \| Administration \| Security \| Deliver \|Options \| Orders

Main Menu - The Favorites Tab

Figure 1 - The Favorites Tab.

The Favorites Tab will store databases that you use often, the folder that they reside in plus a category that you can group like databases together on.

Add Button - This will add a Database to the Favorites Tab. It will bring up the Add / Modify window (Figure 2) with the details of the currently selected database. The database can be given an ID as well as a Cateogry to identify it by. This is handy as sorting of your favorites to quickly find a desired database. If you have a database that needs compacting regularly, you can enter a maximum size that you will allow the database to expand to before it should be compacted. Enter this size in megabytes.

You can also identify the workgroup settings that you want to use when you open the database. If you use more than one version of Access 2000, Access 2002 or Access 2003 on your computer, you can specify the default version of software that you want to open your database with.

Edit Button - Clicking this button, while selecting a current database stored in the Favorite's Tab will allow you to change the database's details as shown in Figure 2. The folder button on this form will allow you to change the location of the database using a File Dialog box.

Add/Edit Favorite Fields

Identifier: This unique name is used to identify all the details of this favorite

Database Path: Location of the database

Category: You can group like databases together with this text code

Auto Compact Size: When the database exceeds this size, the database will be selected for compacting next time you click on this favorite.

Backup Interval: The next time you click on this favorite, the software will check if the last backup has occurred before today minus the interval in days. If so, the database will be selected for backup. Read about backups

Workgroup ID: In the security form you can setup a workgroup Id with Access workgroup file and username settings. Choose the applicable workgroup Id to apply to this database favorite. Leave as No Workgroup to use the default workgroup file.

Preferred Access 2000+ Version: If you are running more than one of Access 2000, 2002 or 2003, you can specifiy which version of Access 2000+ to use for this database. Read more

Database Password If your database has a password (Access menu Tools ~ Security ~ Set Database Password), you can store the same password with your favorite settings. This is the only way that the Who's On User Lists can be retrieved.

Figure 2 - The Add / Modify Window.

Remove Button - Remove a previously stored favorite database.

Reminder button - When you click on this button, you will be able to enter a message that will be displayed when ever you choose this database as a favorite. This brings up a form that looks like the one shown in figure 3.

Figure 3 - Reminders for a database

NOTE: This message when ever a database is selected in the Workbench with the same name as this database. This occurs no matter what folder the database is located in.

Note: You can also setup a reminder for the database using the menu Messages ~ Database Reminder

Sorting Favorites - Single clicking on the Header of the Favorites will sort in Ascending order by that column. Clicking again will re-sort the favorites in Descending order.

Figure 3 - The Column Headers. Click on these to Sort!.

ID - This is the name or identifier that you give to each database in your favorites in the Add Modify window. It can be changed by single clicking on the ID of the record in the Favorites Tab.

Location - This is the Physical location (Full Path) of your stored favorite database.

Category - This is an Identifier that you can use to Group together "like" databases for easy location with a sort. The default is 'My databases'. You could use Clients, Domain Names or Departments to sort your favorites.

> MB - This field allows you to enter the maximum size that you will allow your database to expand to before the compact check box is selected automatically for.

Note: Before using the favorites you should take the time to set up your 'Options' Under the Options Button! Here you set up the location of the Microsoft Access Executable as well as security details if you need to use a Workgroup file to gain access to the database. If you forget, the very first time you try to use a Favorite Database you will be taken to the Options window to fill in these details.

The Access Workbench Help File - The Favorites Tab