Editing a form in a MDE file

I painfully discovered that when i created a database with forms etc in Access 97 and created and MDE file from it, all records are entered in the MDE file and not in the MDB. After a few months of use we want modify the forms but that's impossible in an MDE or is it...
I'd really like to know if it's possible to edit an MDE because all data resides in that MDE file and not in the original MDB file aaargh. The only solution that i see now is to export the data from all tables etc from the MDE to the MDB, then modify the MDB's forms and table to satisfy the needs of my users, then import the exported data and then create a new MDE file.
srodenburgAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TrygveCommented:
Easy solution: Export the tables into a seperate MDB, and link them into your application mdb. This way your compiled MDE will not have any data and you may update it any time you want. It also allows you to have the mde file copied to each users computer, which adds speed and decreases network trafic.

Please let me know if you need additional information.
Hope this helps !
Trygve
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TrygveCommented:
Hi, how are you doing on your problem ?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.