Here's the situation - my friend has a small insurance company. She has been running software from a company that has been out of business since 2004. There is no support for the software available and she doesn't have any installation disks (the software company installed and configured the software). The software is a msql database that is accessed by Msaccess modules. I have been advising her since the software company went out of business to switch to something else but she kept putting it off. As you might guess, the inevitable happened amd her hard drive crashed - badly. She had to send the hard drive to a recovery company and they managed to get her msql database and the Msaccess modules recovered and most of her documents, but little else. They didn't get any of the previously installed OS (win2k) so a repair install was out of the question. I need to get this database back up and running so she can (finally) get the data entered into new software. There are several files associated with the database.
aesql_60.mdf - the database itself
ae.mde list of users (I can open this)
account.mde
config.mde
market.mde
reporter.mde
ae52.ini - points to msaccess and lists path to data
aem.ini - path for backing up database
There is an .exe that is a menu program that calls the various .mde files - which it appears I can bypass.
If I try to open any of the .mdes I get a database is corrupt error (except for ae.mde). I think this is because I haven't got an sql server running. I was able to load the database into msaccess by creating a file DSN in Administrative tools->data sources (I found the info elsewhere on EE) but it just looks like a list of variables.
There is a shortcut folder in the database folder where I can edit the path and startup properties of each msaccess module (eg. C:\Program Files\Microsoft Office\Office11\MSACCESS.E
XE" "C:\eAgency\account.mde" /wrkgrp\Data\WrkGrp\ae.mde
).
So, how can I get this database opened to access the data.
