Solved

Editing a form in a MDE file

Posted on 1998-04-07
2
492 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now