• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Finding a Database File

If you're having trouble locating your file, Access can help you look. Follow these steps to find a file:

  1. Choose File, Open if the Open dialog box isn't already open.

  2. (Optional) If you know part of the name, use wild cards to indicate it.

    Note

    Wild Cards You can use wild cards if you don't know the entire name of a file. The asterisk (*) wild-card character stands in for any character or set of characters, and the question mark (?) wild-card character stands in for any single character. For example, if you know the file begins with P, you can type P*.mdb to find all Access files that begin with P.


  3. (Optional) If you want to look for a certain type of file, choose the type from the Files of type drop-down list.

  4. Click the Tools button to open its menu, and choose Find. The Find dialog box appears (see Figure 6.5).

    Figure 6.5. Use the Find dialog box to select the folders and drives you want to search.

  5. In the Look In section at the bottom of the Find dialog box, narrow the search area as much as possible by using these techniques:

    • If you are sure the file is in a certain folder, type that folder's path (such as C:\WINDOWS) in the Look in box.

    • If you are sure the file is on a certain drive, select that drive from the Look in drop-down list.

    • If you don't know which drive contains the file, select My Computer from the Look in drop-down list.

  6. Make sure that the Search subfolders check box is marked. If it isn't, click it.

  7. If you want to specify any other properties, do so like this:

    1. Open the Property drop-down list and select a property, such as File name or Creation date.

    2. Open the Condition drop-down list and choose a condition. Your choices vary depending on the property you chose in step a.

    3. Type a value to match in the Value text box. It must be appropriate for the property selected. For example, to find a file containing the name John Smith, type John Smith.

    4. Click the Add to List button. The search string you just created appears at the top of the list in the Find Files that match these criteria box.

  8. Click the Find Now button. The File Open dialog box reappears and displays the files that match your search criteria, if any are found.

  9. Double-click the desired file to open it.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint