On Center Home | MyOnCenter Portal | Start an On-Screen Takeoff Trial | Request a Quick Bid Demo | Contact Us | SALES: 1-866-627-6246
   
 
Learn more about Searching
Looking for help for one of ConstructConnect's Other products? Login


Tools
Table of Contents

OST - 20.02.01 Finding an Access-type Database

Views: 1779 Last Updated: 07/20/2023 08:20 am 0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

All Access databases stored in the "Databases" Folder (by default, "C:\OCS Documents\OST") are listed in the Open Databases dialog box automatically.

In the Open Databases dialog box, 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, see Related Articles for information on changing the "default" database folder.

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, on the Main toolbar, or
  • Click File > Open

The Open Databases dialog box opens

OST Open Databases dialog box

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

OST select database type to create

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

OST Databases Properties dialog box

  • Click the Lookup button next to the File name field - the Select MS Access database window opens
  • Browse to the location where the database is stored

OST Find Databases dialog box

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').  See Related Articles for information on setting Program Options, including your Default Folders location.

  • 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.

Warnings!!!
  • 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.)

Opening and Closing Databases Connecting to a Microsoft SQL Database



Product documentation (user guides) describes functionality in the latest version of each major release and may not match the functionality in the version you are using. Please check the Product Information and Downloads pages by clicking one of the product buttons above.

Something Wrong with this Article? Let us Know! Copyright 2023 - On Center Software, Inc. by ConstructConnect - All Rights Reserved.