MDE File

  • Thread starter Thread starter MN
  • Start date Start date
M

MN

Hello,
I deployed an access.MDE file to the user. Can we have the
way let the user add in mde file with a new report (or
queries)?-Thanks,
MN
 
As far as I know there is no way for the end-user to add
anything to an .mde as it removes the coding to do such
once converted from a .mdb
 
The reason that the mde version is created is to prevent a user from either copying or modifying the code. Given that, there is no reason why the users cannot create a new MS Access application and link the tables to your MDE database. The additional user defined and modifiable reports would be created in the new MS Access application. While this is not perfect, it does at least provide some flexibility.
 
Thank you Pj.
BTW, what do you mean by New MS Access application?
Regards,
MN
-----Original Message-----
The reason that the mde version is created is to prevent
Click to expand...
a user from either copying or modifying the code. Given
that, there is no reason why the users cannot create a new
MS Access application and link the tables to your MDE
database. The additional user defined and modifiable
reports would be created in the new MS Access
application. While this is not perfect, it does at least
provide some flexibility.
 
In a previous exercise, I developed a defect tracker application and, because I did not want others making code changes, I released only the MDE version. As you noticed, the major drawback is that the end user cannot add new reports to an MDE version. An alternative is create a distinct but related "report" application.

An MS Access application is a database and can be referenced by another MS Access application. The steps involved in enhancing the reports capability are:
• create/open a new MS Access application (e.g., Business Reports);
• rather than creating any tables, link the tables from the main application to the new application
File -> Get External Data -> Link Tables …
• select the main application (or the LDB file if the application and data were segregated) from where you want the data
• 'Link Tables" window is shown with a list of data tables found within the application
• that window, click on the 'Select All' button and then the 'OK' button

The new application should now have access to all of the data tables and additional forms and/or reports can be developed by the user to fit their needs. This also allows you to keep the main application "pure" while still providing the user with reporting flexibility. Depending on the usage of the application, you probably still need to view the user designed report and query SQL statements to ensure that a user has not included an instance that dramatically reduces the system responsiveness.
 
Back
Top