how to create an executable of MS access application

[infobescom]

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 .

[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!

:)

[infobescom]

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....

[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

[Killer42]

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.

[infobescom]

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

[infobescom]

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

[infobescom]

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 ...

[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

:)

[Qlokoy]

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