By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,384 Members | 714 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,384 IT Pros & Developers. It's quick & easy.

how to create an executable of MS access application

P: 8
currently we have created an MS access application and we want to create an executable of it we did it this way
tools menu -> datadase utilities ->make MDE file

we have got an MDE format of the application and when we load it in another system we are not able to run this MDE file in that system .We have tried to run this MDE file on system having Access and without access but its not wrking any where else other than in our system..

could any one please help us out how to create an executable format of the application created so that it can be put to use as an executable file .
Oct 30 '06 #1
Share this Question
Share on Google+
9 Replies


PEB
Expert 100+
P: 1,418
PEB
Hi,

In fact the mde is always running with MS Access... It's executable coz all the code is compiled and transfered to memory faster than it's interpretation in the mdb file!

But creating an independant exe file!

My friends told me that there is a ptogram that converts mdb files to exe in the tools of Visual Basic but never tried!

But be carefull about!

PS: Also you can use the runtime instance of Ms Access!

:)
Oct 30 '06 #2

P: 8
Hi,

In fact the mde is always running with MS Access... It's executable coz all the code is compiled and transfered to memory faster than it's interpretation in the mdb file!

But creating an independant exe file!

My friends told me that there is a ptogram that converts mdb files to exe in the tools of Visual Basic but never tried!

But be carefull about!

PS: Also you can use the runtime instance of Ms Access!

:)


Well PEB thx for your reply ...
but can i get any info regrading....in wot way can i create an executable now ,of my application i have done so it can be put on different systems for use....
Oct 30 '06 #3

PEB
Expert 100+
P: 1,418
PEB
If i understand well you want to use the mde in other programs?

Or simply you try to run it on other windows with Access and witout Access?

To run on other Windows you need always Access or Access Runtime program! The Access Runtime program is an executable that runs your mde or mdb like a real program whitout visalising standard options of MS Access

And certenly the libraries that you've used if they aren't the standad ones!

Best regards
Oct 30 '06 #4

Expert 5K+
P: 8,434
Another thing to be on the lookout for is linked tables. If tables are linked from another database, then that will have to be in the same location on each machine that you want to run on. I actually ran into that exact problem, today.
Oct 30 '06 #5

P: 8
If i understand well you want to use the mde in other programs?

Or simply you try to run it on other windows with Access and witout Access?

To run on other Windows you need always Access or Access Runtime program! The Access Runtime program is an executable that runs your mde or mdb like a real program whitout visalising standard options of MS Access

And certenly the libraries that you've used if they aren't the standad ones!

Best regards


PEB thx for your reply again

could u pls.. tell me more abt this ACCESS RUNTIME pls... where do i find this in my system ..
and is the mdb an executable of an access application .....is this right assumption

Thanks & Regards
Oct 30 '06 #6

P: 8
Another thing to be on the lookout for is linked tables. If tables are linked from another database, then that will have to be in the same location on each machine that you want to run on. I actually ran into that exact problem, today.


Well Killer42 we are not using any references from other database we have a single DB for this applicatio and we later created the mde format of it ....and we are in confusion abt the wrking of this mde as an executable application

Thanks & Regards
Oct 30 '06 #7

P: 8
i forgot to mention it out that i am using ACCESS 2000 and is their any problem with this ....

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k2/html/odc_acFormat.asp


as per this it says we cant create an mde in 2000---"Additionally, MDE and ADE files can only be created with Access 2002 "...

is this the exact problem i am not able to run the MDE of the application on other system ...
Oct 30 '06 #8

PEB
Expert 100+
P: 1,418
PEB
In this case you need to convert Access 2000 to Access 2002 databse /separete copy

And then from this copy in Access 2002 to create your mde

For Access 2000 the runtime module is:

art2kmin.exe /search it in the net! I've lost the link of it location/

For 2003:

ACCESSRT.MSI or ACCESSRT.CAB

:)
Oct 30 '06 #9

P: 1
Hi Infobescom,

Access Runtime allows you open/run Access application (either an MDB file or MDE) even without installing the full MS Access on the "host" PC.

Here's an article on the subject:

http://msdn2.microsoft.com/en-us/library/aa167800(office.11).aspx

Regards,

Qlokoy
Jan 31 '07 #10

Post your reply

Sign in to post your reply or Sign up for a free account.