Find Databases Wizard (Select Locations) (AccessToSQL)

On the Select Locations page of the Find Databases Wizard, you enter the search parameters for finding Access databases.

To open the Find Databases Wizard, on the File menu, click Find Databases. For more information about how to use this dialog box, see Adding and Removing Access Database Files

Options

Browse
Click to browse the computer or network. Select the folder or location to search, and then click OK. Click Add to add this location to the list.

Path box
Shows the path to add to the locations box. Enter or browse to the path you want to scan, and then click the Add button.

Locations box
Lists the locations SSMA will scan. When you click the Add button, the specified path is added to this box.

Add
Adds the location in the path text box to the list of locations.

Replace
If an item in the list of locations is selected, the item in the path text box replaces the selected item.

Remove
Removes the selected item from the list of locations to search.

All or part of file name
To find databases that have names that contain a specific string, enter the string. Do not use wildcard characters.

Creation date
To find databases that were created within a specific date range, enter the start date in the From box and the end date in the To box.

Last updated date
To find databases that were last updated within a specific date range, enter the start date in the From box and the end date in the To box.

Size
To find databases that match a size criteria, select a comparison character in the first box, enter a number for the size, and then select bytes, kilobytes, or megabytes from the third box.

Owner
Enter the full Windows user name of the owner. This might be formatted as domain\user.

See Also

Adding and Removing Access Database Files
User Interface Reference(Access)