Skip to main content

When you have the Open Databases dialog box open, you can use the Find... function to open a Microsoft Access database stored in a location other than the default directory (C:\\OCS Documents\\OST). By default, all databases stored in the "default location" are always shown in the Open Databases dialog box, this can be changed by clicking Tools > Options > Folders.

  • Never open (work in) any database stored in the "Backup folder" - you will lose your work when the program backups databases into this folder. Make a copy of the database file and place it in your Database folder before opening it.
  • Never store MS Access databases on a network or removable drive.
  • Never share MS Access databases (do not allow more than one person to open an MS Access database at one time.)

Finding a Microsoft Access Database

To "Find" an Access database stored someplace other than the "database" folder:

  • Right-click anywhere in the Bids Tab and select Open, or
  • Click the Open icon, <the Open Databases button looks like a manila folder with a curved arrow at the top on the Main toolbar, or
  • Click File > Open

The Open Databases dialog box opens

The Quick Bid Open Databases dialog box shows you all databases in the Default location and all that you have found previously

  • Click the "Find..." button - the Select Database Type dialog box opens:

The first step in finding a database is to tell Quick Bid whether you are looking for an Access or SQL database

  • Select 'Microsoft Access' and click OK - the Database Properties (Access) dialog box displays

The Quick Bid Access Database properties dialog box - blank

  • Click the Lookup button <the Lookup button looks like a magnifying glass next to the File name field - the Select MS Access database window opens
  • Browse to the location where the database is stored

<browse to the location where your Access database file is stored

Databases stored in the folder specified for databases under Tools > Options > Folders always show in the Open Databases dialog box and cannot be 'removed' or 'found').

  • Highlight the database you want to open and click Open
  • Click OK and the database is shown in the Open Databases dialog box (it will be checked)
  • Click OK to close the Open Databases dialog

The database is visible on the Bids Tab and can be opened/closed like any other.

To remove this database from the Open Databases dialog box list,

  • Highlight the database and click the Remove button.

This does not delete the database or affect any saved Bids - it merely closes the database and removes the reference from this dialog box.

click here to view the previous article Opening and Closing Databases Connecting to a Microsoft SQL Database click here to view the next article

Related Articles

 

Be the first to reply!

Reply


Terms & ConditionsCookie settings