Solved

Editing a form in a MDE file

Posted on 1998-04-07
2
520 Views
Last Modified: 2013-12-05
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.
0
Comment
Question by:srodenburg
  • 2
2 Comments
 
LVL 12

Accepted Solution

by:
Trygve earned 50 total points
ID: 1973428
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
 
LVL 12

Expert Comment

by:Trygve
ID: 1973429
Hi, how are you doing on your problem ?
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question