Solved

Editing a form in a MDE file

Posted on 1998-04-07
2
551 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

636 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