473,785 Members | 2,425 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

how to create an executable of MS access application

8 New Member
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
9 45798
PEB
1,418 Recognized Expert Top Contributor
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
infobescom
8 New Member
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
1,418 Recognized Expert Top Contributor
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
Killer42
8,435 Recognized Expert Expert
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
infobescom
8 New Member
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
infobescom
8 New Member
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
infobescom
8 New Member
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.as p


as per this it says we cant create an mde in 2000---"Additional ly, 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
1,418 Recognized Expert Top Contributor
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
Qlokoy
1 New Member
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

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

Similar topics

3
377
by: Giloosh | last post by:
Hello, i have a microsoft access application and right now, anyone knowing how to use microsoft-access can easily go behind the applicatio, design the forms, delete edit/tables etc... There is basically no security on the application. My question is... how do i secure the application, preventing any access to the "back" or Source (tables,queries,forms,macros...) of the application? or even preventing getting into the design view of the...
10
2386
by: Sue Bricker | last post by:
Is it possible to create an MS/ACCESS database application and package it for users who do not have MS/ACCESS loaded in their PCs? I was told that this is possible, but I don't know what software is needed. Do you know? If so, please answer this post. Thanks. SueB *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!
3
10749
by: James Wong | last post by:
Dear all, I have an old VB6 application which can create and access Excel object. The basic definition statements are as follows: Dim appExcel As Object Dim wkb1 As Excel.Workbook Dim wks1 As Excel.Worksheet Set appExcel = New
9
3453
by: dennist685 | last post by:
I created a web project named 'Access' in C:\Inetpub\wwwroot\Access and dropped an .mdb there. I dragged a DetailView to the form, configured it to show two fields of a table, and got AccessDataSource1. The test query worked. The .mdb was not open in Access, nor was it being used anywhere else. Yet when I pressed Cntl+F5 I got the following error:
38
3909
by: Oldie | last post by:
I have built an MS Access Application under MS Office XP (but I also own MS Office 2000). I have split the application in the pure database tables and all the queries, forms, reports and macro's. Now i want to use this application for different foundations in the Netherlands but I want to secure my application so no one can change it, copy it or steal it from me. I always thought there was a kind of conversion tool that would translate...
6
2171
by: DavidMS | last post by:
I have a production access application with no development environment. We need to create a develoment access environment with an empty db. We are not allowed to see the production data. How do I create a template of the existing db and then use it to create my development environment
2
3743
by: Steve | last post by:
I have zero experience with ODBC. If I have an Access frontend connected to a SQL Database using ODBC, are the tables connected like a frontend/backend Access database where the the tables you see in the frontend are only "copies" of the tables in the backend? Or ar the tables "real" tables connected to the SQL tables in some manner? If the latter, can an Access table have more fields than the SQL table it is linked to? The reason for my...
0
1147
by: vedrandekovic | last post by:
Hello, Is there any example how can I create executable from executable with py2exe.For example if I create main executable with some TextEntry ( wxpython ) and then when i write this code into this entry: import os print os.getcwd() print "ok"
0
1225
by: singhPrabhat | last post by:
Hi, I am using 64-bit linux box (Open Suse 10.3 ). I want to create executable for windows box. how can I use Makefile to create executable for windows? I can see some .dll files which I seem required at time of linking libeay32.dll msvcr71.dll
0
9646
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10346
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10157
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10096
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7504
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6742
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5386
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
3658
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2887
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.