AutoCAD Electrical General Discussion

AutoCAD Electrical General Discussion

Reply
Active Member
tfite
Posts: 9
Registered: ‎07-27-2001
Message 1 of 6 (145 Views)

Multi-user database access from a network

145 Views, 5 Replies
07-26-2004 10:11 AM
Assuming that a project had a number of users that each had been assigned a number of drawings in a project, how does the scratch database get updated? Is the database locked by a single user, or can multiple users write to the project database over a network?

I have a customer that pointed out how SQL Server allows multi-user access to database tables, where Access does not.

Thoughts? This customer was really down on ACADE when he found out that Access was the DB of choice....
*Expert Elite*
testsubject
Posts: 1,096
Registered: ‎03-09-2004
Message 2 of 6 (145 Views)

Re: Multi-user database access from a network

07-26-2004 10:48 AM in reply to: tfite
MS Access allows multi-user access to the database. I do not know where your customer got his info. There is a problem when reports are modified but that would not affect how ACE uses the database, AFAIK.
Bob Hanrahan
Ace User since 1998
Member
TomJ
Posts: 4
Registered: ‎07-23-2004
Message 3 of 6 (145 Views)

Re: Multi-user database access from a network

07-26-2004 11:32 AM in reply to: tfite
Access isn't an "enterprise strength" dbms, we are wrestling with the same thing.
Valued Contributor
Jay Mackey
Posts: 62
Registered: ‎06-21-2004
Message 4 of 6 (145 Views)

Re: Multi-user database access from a network

07-26-2004 04:51 PM in reply to: tfite
My understanding is that Access mdb's are OK for up to 25-30 simultaneous users in general, although these numbers may have been a theoretical max and apply to heavy intranet or internet usage. Sure, that is not 'enterprise' level, but it is fine for any electrical design project that I've ever heard of. Lot's of apps use .mdb's internally, including at least one (if not all) of the major competitors to ACADE, and an app that I've used a lot called Parts and Vendors, a multi-user BOM database application. "Enterprise" would generally refer to 100's of simultaneous users.

That said, your milage will certainly vary depending on how efficiently and intelligently the application uses the .mdb.

Incidentally, I doubt you will ever see any ECAD systems use SQL Server any time soon. That would like swatting a fly with a sledge-hammer, even if it is a really light, well-balanced, super-duper, multi-user one. That just means the expense of licensing it for use in your app would be greater than your profit margin. Of course, that might not be a problem with ACADE. :0
*Nate Holt
Message 5 of 6 (145 Views)

Re: Multi-user database access from a network

07-27-2004 05:29 PM in reply to: tfite
The default install is that the project scratch database files are kept on the user's local machine. When multiple users are working on a common project, each user's copy of AutoCAD Electrical maintains its own up-to-date copy of the scatch file locally. So, under this install condition, by default, there is never more than one user accessing the project scratch database file. "tfite" wrote in message news:992982.1090861923395.JavaMail.jive@jiveforum2... > Assuming that a project had a number of users that each had been assigned a number of drawings in a project, how does the scratch database get updated? Is the database locked by a single user, or can multiple users write to the project database over a network? > > I have a customer that pointed out how SQL Server allows multi-user access to database tables, where Access does not. > > Thoughts? This customer was really down on ACADE when he found out that Access was the DB of choice....
Valued Contributor
Jay Mackey
Posts: 62
Registered: ‎06-21-2004
Message 6 of 6 (145 Views)

Re: Multi-user database access from a network

07-28-2004 06:50 AM in reply to: tfite
You also have to check a box to make the scratch database sharable. This is in Misc. Project Settings. Press the Misc. Settings button on the main Project dialog.

- Jay
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

Start with some of our most frequented solutions to get help installing your software.

New AutoCAD Electrical Category!

The AutoCAD Electrical forum has moved into it's very own category page, and can no longer be found within the Additional Product Forums.

Announcements
Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.