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.


Warning

  • 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


Note

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