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

Table of Contents

OST - 20.07 Multiple Concurrent Users in an SQL Databases (Database Sharing)

Views: 1925 Last Updated: 11/04/2022 11:52 am 0 Rating/ Voters
Be sure to rate this article 5 Stars if you find it helpful!

Your SQL-type databases may be shared among different users working at different workstations. On Center Software Technical Support does not provide assistance with configuring your network, SQL Server, or various security settings required to use SQL database  - you are responsible for setting up, administering, and maintaining networks, SQL Servers, and user accounts. All questions regarding networking are best directed to a local IT Professional.

See previous and Related articles for more information on creating and using SQL databases.

Never store Microsoft Access databases on a network drive or allow more than one user to open them at a time.  Although On-Screen Takeoff can open a Microsoft Access-type database stored in a network local or shared drive, your database will become damaged and unusable. SQL database are the only acceptable method for sharing databases or storing data on a network location.

When sharing databases, it is recommend that all databases be set to "Require Login" and that you have setup Employee "Access Levels", see the previous article for more information on using program-level security to limit what users can see/do.

When sharing a database, keep in mind that only one user may work on a Project at any one time. The first user to open the project (activate the Image, Takeoff, or Worksheet Tab) locks the Bid and he or she is the only person to edit the project. Once that person closes the Bid (opens another Bid, closes the database, or shuts down On-Screen Takeoff), another user will be able to open/edit the Bid. For a truly collaborative takeoff experience, consider ConstructConnect Takeoffhttps://www.constructconnect.com/takeoff-estimating-software.

See CLS - Best Practices for Best Practices and Recommendations.


That's it! This is the last article of the On-Screen Takeoff User Guide. Great job!

Be sure to check out the other On-Screen Takeoff resources on the Product Information and Downloads Page and the On-Screen Takeoff Training Resource.

 Setting a Database to Require Login

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.