Post reply

Warning: this topic has not been posted in for at least 120 days.
Unless you're sure you want to reply, please consider starting a new topic.

Note: this post will not display until it's been approved by a moderator.

Name:
Email:
Subject:
Message icon:

shortcuts: hit alt+s to submit/post or alt+p to preview

Please read the rules before you post!


Topic Summary

Posted by: Brian Neumann
« on: May 02, 2007, 11:39:09 AM »

I have played a game of Starfire where everyone used the same database from multiple sources.  We had some problems with two people trying to do something at the same time, but it was fairly rare.  We also only updated one month every 3 days.  I do not think that Aurora will work as well if you wanted to try it as everything is done on a more real-time scenario.

Brian
Posted by: Erik L
« on: May 02, 2007, 11:23:56 AM »

Quote from: "Steve Walmsley"
Quote from: "coldsteel"
will these errors over time cripple the .MDB file?
No, if they happen it will prevent an update rather than causing corruption. There is also a remote possibility that two players could lock each other out of the same record and both have to Ctrl-Alt-Delete but even then, no update would take place. The best idea is to try it as I am going on theory here rather than practical experience.

Steve


It is possible, but as Steve points out, at some point, a lockout will occur. Two players hopping into the same system?

One possible way around this, if Steve wants to do such work, would be to move from Access to the SQL Server desktop engine. It would require rewriting all of his database access code, and porbably a bit more. So I sort of doubt that it'd happen ;)
Posted by: Steve Walmsley
« on: May 02, 2007, 11:00:22 AM »

Quote from: "coldsteel"
will these errors over time cripple the .MDB file?

No, if they happen it will prevent an update rather than causing corruption. There is also a remote possibility that two players could lock each other out of the same record and both have to Ctrl-Alt-Delete but even then, no update would take place. The best idea is to try it as I am going on theory here rather than practical experience.

Steve
Posted by: coldsteel
« on: May 02, 2007, 10:49:26 AM »

will these errors over time cripple the .MDB file?
Posted by: Steve Walmsley
« on: May 01, 2007, 04:36:11 PM »

Quote from: "coldsteel"
Steve, can SA be played over a LAN and have multiple players accessing their empires at the same time?

Theoretically yes, but Access doesn't handle multi-user very well so its possible you might get an occasional error if two players try to access the same database record at the same time.

Steve
Posted by: coldsteel
« on: April 28, 2007, 01:20:25 AM »

Steve, can SA be played over a LAN and have multiple players accessing their empires at the same time?