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: Tregonsee
« on: December 04, 2008, 11:20:55 AM »

What I would like to do is add fleet data to an existing database so I can use the battle resolver. It is a shame that the battle resolver cannot take other databases for input.

Steve G
Posted by: Steve Walmsley
« on: December 04, 2008, 10:55:44 AM »

Quote from: "Tregonsee"
Ok, thanks all.  I think I will not have to worry about size for a while then.  Now is there a way to combine certain aspects of two databases together?  I need to be able to add fleet data from one database to another in order to use the battle calculator
No, you can't combine databases because of the Unique ID problems. I guess it would be possible to write an application to do it, depending on what information you wanted to combine, but it would be a lot of work.

Steve
Posted by: Tregonsee
« on: November 29, 2008, 12:36:06 PM »

Ok, thanks all.  I think I will not have to worry about size for a while then.  Now is there a way to combine certain aspects of two databases together?  I need to be able to add fleet data from one database to another in order to use the battle calculator
Posted by: Shinanygnz
« on: November 29, 2008, 08:38:12 AM »

The limit is 2Gb I think, same as MSDE.
There's an option on the Miscellaneous menu in SA to Compact the database.
Access is a swine for growing the db, so use the option provided by the good Mr W

Stephen
Posted by: Kurt
« on: November 29, 2008, 08:00:10 AM »

Quote from: "Tregonsee"
I am not sure about how to compact them (I have never used Acess), but if there is no upside limit, then it does not matter, right?  Or I can wait until it gets closer to that upside limit.

Steve G


The is a limit on size, but I believe it is close to 1,000 meg's.  

Kurt
Posted by: Tregonsee
« on: November 28, 2008, 07:53:57 PM »

I am not sure about how to compact them (I have never used Acess), but if there is no upside limit, then it does not matter, right?  Or I can wait until it gets closer to that upside limit.

Steve G
Posted by: Erik L
« on: November 27, 2008, 11:00:08 AM »

In Access, compact the databases before combining them. That will probably help some.
Posted by: Tregonsee
« on: November 26, 2008, 05:36:09 PM »

Is there a maximum size of the database in SA?  Is it dependent on the version (SA 7.0 can handle a large (over 100mb) database better than older versions)?

I am about to take a 147mb database, add more data to it, in order to run battles and stuff.  Do I need to trim the size of the database, and if so, how can I easily trim the size?

Steve G