Author Topic: Strange question, but....  (Read 3052 times)

0 Members and 1 Guest are viewing this topic.

Offline coldsteel (OP)

  • Sub-Lieutenant
  • ******
  • Posts: 101
Strange question, but....
« 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?
« Last Edit: December 31, 1969, 06:00:00 PM by coldsteel »
ziggy zoggy ziggy zoggy oi oi oi!
ziggy zoggy ziggy zoggy oi oi oi!
ziggy zoggy ziggy zoggy oi oi oi!
<chug>
 

Offline Steve Walmsley

  • Aurora Designer
  • Star Marshal
  • S
  • Posts: 11644
  • Thanked: 20341 times
Re: Strange question, but....
« Reply #1 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
« Last Edit: December 31, 1969, 06:00:00 PM by Steve Walmsley »
 

Offline coldsteel (OP)

  • Sub-Lieutenant
  • ******
  • Posts: 101
(No subject)
« Reply #2 on: May 02, 2007, 10:49:26 AM »
will these errors over time cripple the .MDB file?
« Last Edit: December 31, 1969, 06:00:00 PM by coldsteel »
ziggy zoggy ziggy zoggy oi oi oi!
ziggy zoggy ziggy zoggy oi oi oi!
ziggy zoggy ziggy zoggy oi oi oi!
<chug>
 

Offline Steve Walmsley

  • Aurora Designer
  • Star Marshal
  • S
  • Posts: 11644
  • Thanked: 20341 times
(No subject)
« Reply #3 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
« Last Edit: December 31, 1969, 06:00:00 PM by Steve Walmsley »
 

Offline Erik L

  • Administrator
  • Admiral of the Fleet
  • *****
  • Posts: 5654
  • Thanked: 366 times
  • Forum Admin
  • Discord Username: icehawke
  • 2020 Supporter 2020 Supporter : Donate for 2020
    2022 Supporter 2022 Supporter : Donate for 2022
    Gold Supporter Gold Supporter : Support the forums with a Gold subscription
    2021 Supporter 2021 Supporter : Donate for 2021
(No subject)
« Reply #4 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 ;)
« Last Edit: December 31, 1969, 06:00:00 PM by Erik Luken »
 

Offline Brian Neumann

  • Vice Admiral
  • **********
  • Posts: 1214
  • Thanked: 3 times
(No subject)
« Reply #5 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
« Last Edit: December 31, 1969, 06:00:00 PM by Brian »