MDE Editing

A

AccessNewbie

I have only been using access 2003 for a few months now. All of the programs
that I use were already in place when I started this job and they are are
mde. I've been trying to read about mde and I'm not sure I understand it.
According to what I understand you cannont edit an mde file. However, the
person who used to work in my office says you can edit it, but it can only be
edited in code. So, how do I get to the code? Can I copy it into a new
database so I can make some editing changes on the reports? Additionally, I
have been told that the original files were shredded so I can't get those
either. Can an mde be converted back to access? Thanks and hope this makes
sense.
 
A

Allen Browne

An MDB contains 2 copies of the code:
- a text version (this is what you read and edit),
- a complied version (this is what executes.)

An MDE contains on the compiled version. Therefore it is not possible to
read or edit the code in an MDE. Additionally, the Design button is greyed
out for forms and reports in an MDE, so you cannot modify them.

With professional help, it is possible to create an MDB out of an MDB, e.g.:
http://www.everythingaccess.com/mdeconversion.htm
 
J

John W. Vinson

I have only been using access 2003 for a few months now. All of the programs
that I use were already in place when I started this job and they are are
mde. I've been trying to read about mde and I'm not sure I understand it.
According to what I understand you cannont edit an mde file. However, the
person who used to work in my office says you can edit it, but it can only be
edited in code. So, how do I get to the code? Can I copy it into a new
database so I can make some editing changes on the reports? Additionally, I
have been told that the original files were shredded so I can't get those
either. Can an mde be converted back to access? Thanks and hope this makes
sense.

http://www.granite.ab.ca/access/createmdbfrommde.htm

John W. Vinson [MVP]
 
T

Tony Toews [MVP]

John W. Vinson said:
Is it up to date?

It is now. I kept forgetting to add the link to the MDE>MDB tool.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top