first a couple of tips...
1) don't use the access database files. Install postgres and run from that - it's better, faster, and can hold more hands. The access db will quickly become overwhelmed particularly if you're storing observed hands.
2) use a separate db for observed hands
3) back up your db frequently - I do mine once a week at least. And I keep the original HH's for at least a month after that.
4) run the db maintenance - I never wait to be told I usually run it just after I do the backup
Now to your problem. If you can open the db first back it up (just copy the mdb file) and perform an extract of the hh's. If you don't store the whole hh for observed hands you'll lose your observed hands - hopefully that isn't the case. You can also try running the DB backup utility - I'm not sure if that works for the access db or not.
You do not need to reinstall, simply create a new db (after installing postres!) and import the hh's into the new db (in fact create 1 db's, one for your observed hands). If you were able to run the backup utility then you may be able to restore the data in to the new db - I haven't tried this.
Worst case - if the file is readable - you should be able to make an jdbc connection to it (with a free tool like ). With that connection you can extract the raw data into a sql file and dump it into the postgres db. If you don't know what I'm talking about shoot me an email and we'll work something out - worst case you can send me your files or let me d/l them or something...
|