Community discussion forum
is it possible to create exe file for access file
-
is it possible to create exe file for ms-access file like vb file.
-
-
Hi albert
1st Save a copy of your mdb file in another directory (Back up)
then Open Access with no db, Choose Convert to MDE and select the database you want to use. This should create an executable MDE file. It will only display forms and reports, NO TABLES or QUERIES shown.Regards
DoctorMahdi
-
Be aware, an MDE is not an executable file.In other words, your DB will not be a standalone DB
-
When I try to create an mde file I get the following error message:
This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.More information about this error message online.Does anybody have any idea what could be wrong? The database is a very small database that was created in Access 2000 that I converted to Access 2002-2003; maybe that could be the problem?
-
there is no wrong with your database, needed to update your jet engine. change the version on your code.
cheers,
-
I frequently create MDE files and making a MDB MDE DOES carry the tables and queries with it in Access 2000.
As to whether it is a true exe file Iam not sure since I have not tried it on a platform without msAccess installed.
-
I repeat, you cannot create an exe file from an Access DB. Access files are containers. They contain objects and data. They cannot be converted to .exe files.
You can use the Visual Studio Tools for the Microsoft Office System to create an installation package that includes your application along with the MSAccess.exe runtime file to run your application. -
Smith and Sussman say about MDE
1. It is NOT an executable file
2. It DOES contain a copy of ALL the database objects EXCEPT modeules. They are compiled in the source database and then transfers them to the target database.
Access MDE files will NOT run as standalone applications precisely as Tanus says.
However I have never tried to do so and have a tendency to investigate despite compelling statements from experts (which I must declare I am not). So many times I have found thast many who are more expert than I simply quote and have not tried.
This is not to be takrvn as a knock at experts but encouragement to novices to try for themselves.
-
Yes, it's possible but you need to convert your Access forms, modules and reports to a project in a compliable language and then build an executable program. Visit www.microtools.us website. Their Access Whiz converters allow you to convert Access to VB6/VB .NET/C# projects that you can build your exe file.
Post a reply
Related discussion
-
Can't print on the network with MSADESS ??
by anatha1 (2 replies)
-
insert in master table and update in other table
by shahid123 (0 replies)
-
Replace record in access with vb 6.0
by concon (1 replies)
-
what is purpose of !ispostback property asp.net
by shahid123 (0 replies)
-
how movies can be encode into flv
by shahid123 (0 replies)
Quick links
Recent activity
- nancy smith replied to How to convert mts to mov o...
- nancy smith replied to How to play MTS/M2TS with q...
- scofield sofia replied to Convert 3GP to video for Mac?
- chicken007 chicken007 replied to Share some useful tools for...
- mary g replied to visual basic project
- mary g replied to visual basic project
Enter your message below
Sign in or Join us (it's free).