Microsoft Access® databases are the default database-type used by Quick Bid and require no additional software to create or use. By default, Access databases are stored at "C:\OCS Documents\Quick Bid" although this location may be changed by setting a new "Database Folder" location in Tools > Options > Folders. (See Related Articles for more information about setting Quick Bid's Folder options.)
The video and some screenshots below are taken in On-Screen Takeoff, but the same procedures apply to Quick Bid.
Access databases must not be shared (opened by more than one person at a time) or stored on a network drive. To share data with other users, use an SQL
database. See the next article for details on creating an SQL
Database.
Create an Access Database
Quick Bid makes creating new databases very easy and does all the hard work for you.
- Click File > New > Database, or
- Click the New icon drop down
then click Database, or - Right-click anywhere within the Bids Tab and select New > Database from the Context Menu
The New Database Type dialog opens
Select "Microsoft Access Database (Most Users)" - the Database Properties (Access) dialog box opens
- To create the database in the default location just type in the name in the File Name box
- To create the database in a location other than the default location, click the Lookup button
and browse to the desired location and enter a file name for the database - the full file location pathway is displayed in the File name field
Database names must not contain special characters such as the following symbols: \ / : * ? ’ ; < > "; only standard alpha-numeric English characters should be used. See
File Path and File Name Character Limitations for more information.
The "Requires login" option is only available after the database is created. To make the database password protected, follow these steps to create it, add appropriate Estimators to the database, then come back to Database Properties and check the box for this feature. See the articles that follow for more information about securing your databases.
In the Measure mode field, select either Imperial or Metric as the system of measurement to use. All UOM boxes in the application are based on this setting. Do not mix Imperial and Metric Bids in the same database and do not connect an Imperial OST database to a Metric Quick Bid database (and vice versa).
Select how often the Auto-backup utility should make a backup copy of the database and indicate the number of backups to retain. At the scheduled time, performs the auto-backup upon application close. See the articles that follow for more information on backing up and restoring databases.
Set the number of backup copies of the database to be stored in the No. of Backups field - once this number is reached, the program begins overwriting the oldest backup copy of the database.
Select how often the Auto-Compress utility should compress the contents of the database to save hard disk space. (This is not a substitute for performing routine maintenance on your database, see Related articles.)
Click OK
The Default Backup settings only backup your database once a week and only store the two (2) most recent copies of the database. You may want to increase the frequency and number of backups.
The database is created and shown on the Bids Tab.
Connecting to a Microsoft SQL Database