Converting a Microsoft Access Database to an MDE File
To help lock down and prevent certain objects especially Forms, Reports and any code being modified (via the design mode), you can convert your database file into an ‘executable‘ file format where the .MDB becomes a copy as an .MDE and the .ACCDB to a .ACCDE.
The Microsoft Office suite of software was developed for novice users to suit those not necessarily interested in development. To simplify database development, Microsoft Access embeds database applications, developed using Microsoft VBA programming, with database tables, objects and other components. Microsoft Access stores these database components in a single file, using the .mdb extension.
If you've written an MDB database file, and you want to let other users perform applications with it, but don't want them to change any codes, change it to an MDE file, another type of Microsoft Access file. In MDE, however, you can't change how the database and macros work. Learn how to convert the MDE file back to an MDB (modifiable) file.
I tried to compile my MDB database into an MDE file, but I received the error: "Microsoft Access was unable to create an MDE database." There weren't any other error messages. How can I find out what the problem is?
A common question in Access database newsgroups and forums is 'How can I convert my Access database from MDE format into an MDB file?' If your file contains VBA code then the correct answer is that you can't since the MDE file is locked and protected. However, the protection isn't the main obstacle in trying to convert the MDE file, the main issue is that all VBA modules are saved in a compiled state with any original source-code being stripped out.
Related Applications & Scripts
MS Access to MySQL database synchronization application is reliable solution to convert bulk MS Access database into MySQL database server. MS Access to MySQL database conversion program quickly transforms entire or selected MS Access database records into MySQL server without any data loss. MS Access database migration software is available with an advanced feature to merge converted MS Access data with existing MySQL database.
You have a Microsoft Access database and want to convert it into mysql? Even in certain time inverals? Then we have the right thing for you: DB Converter!
DB Converter converts any Access database into sql commands, that you can easily import into your mysql database. By wish this jobs are done automatically. Every seconde there can be converted about 2000 sets!.
Ublog Reload is a complete weblog system that will make your web site look more professional!
Ublog Reload, written entirely in ASP/VbScript, allows an easy, flexible integration into any webpage with on-line configuration. Ublog Reload presents a modular design and is database driven ( Microsoft Access, Microsoft SQL Server or MySql Server - on-line database creation script for Microsoft SQL Server and MySql Server version is available ).
Option to run multiple weblogs from one database ( Microsoft SQL Server and MySql Server versions )
Ublog Reload is a W3C valid XHTML 1.0, CSS, RSS and ATOM.
Manage data, create GUI data forms and PHP web pages, administrate databases.
DBACentral for MySQL is a GUI solution for database administration and data management, which provides you with Microsoft Access like interface paradigm for executing all database operations over database structure and table data.
DBACentral for MySQL now with PHP web pages and SSH tunneling!
Support of web grids and forms includes: auto-creation from tables, views, and forms, a comprehensive wizard, an ability to design pages in the WYSIWYG mode and edit their HTML sources, and the built-in web browser.
- import from MS Access or any other ADO-compatible source
- reverse engineer MS Access database structure, including table relationships
- transfer data from MS Access, MS Excel, HTML, XML, etc.
- feel comfortable with the familiar Access-like interface paradigm.
PonVFTP is a compact Online File Manager. It has been designed to be very easy to setup, requiring no database, and is very easy to use. Includes support for a multi-user system that features levels of access and the ability to set home directories. In addition to this, anonymous access can be configured.