Recover MDB from MDE?

[garyca]

I need to upgrade a MS Access 97 MDE file to MS Access XP.

My client has lost the MDB file though.

Is there anyway to recover the MDB or is it gone for good?

I know passwords are recoverable so I'm hoping MDB's can be too.

 

[Pat Hartman]

Not a chance. All the code is actually removed from the db when it is turned into an .mde. The tables and queries can be imported to a new db but the forms, reports, and any code modules are gone forever.

 

[stinej]

Pat,

I'm wondering a bit about this myself, but with a little bit of a different twist. I've developed a database that I have packeged for my users (packaged using the access developer extensions), however I can't quite figure out if I can upgrade a user to a new version and keep their existing data? Is this possible? Each user uses their own copy of the software, which holds their own individual data - I want to make upgrades avaialble to them as they are developed.

Any info, or direction to where I might find the answer is appreciated.

Thanks.
J

 

[ghudson]

You need to split your db. The front end contains everything but the tables that you want to share. The back end contains the tables. The front end must be linked to the back end. That way you can easily replace the users front end with your latest and greatest version of your application without wiping out their data which is in the back end. There is more work to it than that but that is a simplified explanation.