1,105,371 Community Members

How to make a form in Ms-Access as EXE file?

Member Avatar
elanch
Newbie Poster
23 posts since Jul 2007
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

hi all!
I need to make a form in Ms-Access as EXE file. So that the file can be runned without opening Ms-Access. I know that, it is possible in Vbasic but whether it is possible to do in Ms-Access.
Thanks

Member Avatar
kb.net
Junior Poster
169 posts since Aug 2007
Reputation Points: 0 [?]
Q&As Helped to Solve: 29 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi,

The best you can do do is to create an mde file with hiding the database window and menues and running a startup form. This is the nearest you can do to simulate an exe.

Member Avatar
K7AAY
Newbie Poster
12 posts since Jan 2008
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

The Developer version of Access has a run-time compiler so you can do this, but there are significant limitations in what you can do with a run-time, e.g., no datasheet views, no macros, other issues.

Member Avatar
kb.net
Junior Poster
169 posts since Aug 2007
Reputation Points: 0 [?]
Q&As Helped to Solve: 29 [?]
Skill Endorsements: 0 [?]
 
0
 

Hi,

I have used lately the developer extensions of access and they don't actually create you a stand alone wersion of your mde or mdb but:
It will create you an installation file with the ability of including access run-time version. Access run-time will install a copy of access with out the IDE, that is the minimum for access to run.
When running the exe (the installation file) your access database will be deployed on the computer with the run-time and the access path will be sent to the run-time through the shortcut (as a parameter).
If you are using alot of libraries and external controls or in case of failure you will face alot of problems as you will not be able to debug as the access run-time will not alow debugging.
A developer license is more expensive than basic.
Generally after using the access run-time over 8 pcs I have decided to go back and install the full version of access mainly for debugging purposes.
And till the moment I never found a tool that transfers an access file to an exe directly, actually I read about some applications that converts access forms to VB forms but havn't had the chance to test any. But any way I hope it is true :)

Member Avatar
jbennet
Moderator
17,127 posts since Apr 2005
Reputation Points: 1,618 [?]
Q&As Helped to Solve: 736 [?]
Skill Endorsements: 38 [?]
Team Colleague
Featured
 
0
 

no

Member Avatar
K7AAY
Newbie Poster
12 posts since Jan 2008
Reputation Points: 0 [?]
Q&As Helped to Solve: 1 [?]
Skill Endorsements: 0 [?]
 
0
 

The Developer version of Access has a run-time compiler so you can do this, but there are significant limitations in what you can do with a run-time, e.g., no datasheet views, no macros, other issues.

I stand corrected. The Developer version has a runtime you can ship with the VBE, but does not generate an EXE.

Member Avatar
adhikariprakash
Newbie Poster
1 post since Oct 2008
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
1
 

hi all!
I need to make a form in Ms-Access as EXE file. So that the file can be runned without opening Ms-Access. I know that, it is possible in Vbasic but whether it is possible to do in Ms-Access.
Thanks

Member Avatar
boblarson
Junior Poster in Training
77 posts since Jan 2008
Reputation Points: 15 [?]
Q&As Helped to Solve: 8 [?]
Skill Endorsements: 0 [?]
 
0
 

hi all!
I need to make a form in Ms-Access as EXE file. So that the file can be runned without opening Ms-Access. I know that, it is possible in Vbasic but whether it is possible to do in Ms-Access.
Thanks

The short answer is NO, you cannot do this the way you are wanting. You've been given what IS possible by kb.net. You CANNOT, under any circumstances, make an EXE file out of an Access database or form.

If you need an exe file, you need to create it in a programming language such as VB6, VB.NET, VC#, VC++, JAVA, etc.

Member Avatar
buddylee17
Practically a Master Poster
668 posts since Nov 2007
Reputation Points: 216 [?]
Q&As Helped to Solve: 137 [?]
Skill Endorsements: 2 [?]
 
0
 

Make the exe in Visual Studio. Access is a desktop database platform, not a software developing platform.

Member Avatar
Petre
Newbie Poster
1 post since Aug 2010
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Use application ZCureIt. I think it is what you need.
Regards

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: