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: hseldon
« on: April 23, 2011, 08:04:31 AM »

Thank you for the help. 

I'm using Windows XP SP3.   I tried doing a search for any *.  mdb files and windows only found the backup, current, and the original in the setup file.  

I'll try searching the forum to see if I can weed out the location. 

Does it matter what version of MS Office I use? The last version I have is 2003.  
Posted by: jseah
« on: April 23, 2011, 05:50:43 AM »

If you can get the DB to open in M. Access, you can use M. Access's own compactor (happens when you exit).  Maybe that'll work. 

EDIT:
Also, I've tried using the compact Database function.  The current DB gets compacted and a backup is created. 

The compact DB gave me problems though, so I can't use that function. 
Posted by: sloanjh
« on: April 22, 2011, 07:57:15 PM »

Quote from: hseldon on April 22, 2011, 07:45:08 PM
What happens if the database gets too big?

I'm 116 years in and my database is 1.  2 gigs.    I've tried compacting it but always get error 429 "ActiveX component can't create object" followed by a string of error 3420 "Object invalid or no longer set".    Aurora then closes and the database is still the same size.  

It would be a shame if I couldn't continue the game.

My recollection is that there's a 2gig limit on DB size.  On the error you're seeing, are you using Windows 7 or Vista?  There's been some weird problems with the way their permissions system interacts with the installer - I wonder if similar issues might show up with the compator.

Another (random) thought:  I have a VERY vague recollection that the compactor might create a new, compact, DB in another location, rather than stomping your existing one.  I would search the boards for threads discussing the compator function - I think I remember it took a while to work everything out.  It might be that it successfully made a file for you, even though it threw an error....

John
Posted by: hseldon
« on: April 22, 2011, 07:45:08 PM »

What happens if the database gets too big?

I'm 116 years in and my database is 1.  2 gigs.    I've tried compacting it but always get error 429 "ActiveX component can't create object" followed by a string of error 3420 "Object invalid or no longer set".    Aurora then closes and the database is still the same size.  

It would be a shame if I couldn't continue the game.