Access .mde Editing

[Andyb7901]

Hi,

I have an Access Database that I have inhertid which I need to edit. The only problem is it is a .mde file. Does someone know a way I can return it to a normal access file? Or simply edit areas such as VBA, or the forms?

Thanks

 

[Remou]

I do not believe that this is possible.

 

[Andyb7901]

What do you think I could do? Is there anything?

 

[jrbarnett]

Find the original MDB file, edit that, recreate an MDE.

John

 

[Ed2020]

Sorry Andy,

As John and Remou have said - there isn't much you can do.

MDE files are fully compiled and all VBA source code is removed.

Technically it would probably be possible to reverse engineer the compiled code, but I've never seen a utility that does this for MDE files so you'd have to do it by hand. Not a realistic option really....

Ed Metcalfe.

Please do not feed the trolls.....

 

[Andyb7901]

Bugger!

 

[KenReay]

Hi

Maybe a glimmer of hope. I have come across situations where enterprising users/tinkerers, have simply renamed an MDB file with an MDE extension as a means of preventing others from making changes, rather than make a true MDE file. If this is the case for your MDE, simply renaming it back to .MDB will allow you in. Worth a try.

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[jrbarnett]

Its worth checking Ken's suggestion out - the easy way to check is using the technique in: faq705-3569

Open the immediate window and type:
? CurrentDb.Properties("MDE")

If it says "T" then you have an MDE file, if you get a "Property not found" error then its a normal access database.

John