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

Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Reply

Join Date: Jul 2007
Posts: 23
Reputation: elanch is an unknown quantity at this point 
Solved Threads: 0
elanch elanch is offline Offline
Newbie Poster

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

 
0
  #1
Aug 27th, 2007
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
Defeat the defeat before the defeat defeats you
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 160
Reputation: kb.net is an unknown quantity at this point 
Solved Threads: 26
kb.net's Avatar
kb.net kb.net is offline Offline
Junior Poster

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

 
0
  #2
Aug 27th, 2007
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.
Reply With Quote Quick reply to this message  
Join Date: Jan 2008
Posts: 12
Reputation: K7AAY is an unknown quantity at this point 
Solved Threads: 1
K7AAY's Avatar
K7AAY K7AAY is offline Offline
Newbie Poster

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

 
0
  #3
Feb 1st, 2008
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.
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 160
Reputation: kb.net is an unknown quantity at this point 
Solved Threads: 26
kb.net's Avatar
kb.net kb.net is offline Offline
Junior Poster

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

 
0
  #4
Feb 1st, 2008
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
It is never about the number of languages you know, you either have the logic of programming or you don't ...

Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.
Reply With Quote Quick reply to this message  
Join Date: Apr 2005
Posts: 16,157
Reputation: jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all jbennet is a name known to all 
Solved Threads: 531
Moderator
Featured Poster
jbennet's Avatar
jbennet jbennet is offline Offline
Moderator

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

 
0
  #5
Feb 1st, 2008
no
If i am helpful, please give me reputation points.
Reply With Quote Quick reply to this message  
Join Date: Jan 2008
Posts: 12
Reputation: K7AAY is an unknown quantity at this point 
Solved Threads: 1
K7AAY's Avatar
K7AAY K7AAY is offline Offline
Newbie Poster

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

 
0
  #6
Feb 4th, 2008
Originally Posted by K7AAY View Post
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.
--
John Bartley K7AAY PDX OR USA
Reply With Quote Quick reply to this message  
Join Date: Oct 2008
Posts: 1
Reputation: adhikariprakash is an unknown quantity at this point 
Solved Threads: 0
adhikariprakash adhikariprakash is offline Offline
Newbie Poster

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

 
0
  #7
Oct 5th, 2008
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
Reply With Quote Quick reply to this message  
Join Date: Jan 2008
Posts: 44
Reputation: boblarson is an unknown quantity at this point 
Solved Threads: 3
boblarson boblarson is offline Offline
Light Poster

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

 
0
  #8
Oct 5th, 2008
Originally Posted by adhikariprakash View Post
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.
Bob Larson, Access MVP
____________________________________
For Quick Tutorials and Samples for Microsoft Access: BTAB Development
Reply With Quote Quick reply to this message  
Join Date: Nov 2007
Posts: 596
Reputation: buddylee17 has a spectacular aura about buddylee17 has a spectacular aura about 
Solved Threads: 125
buddylee17's Avatar
buddylee17 buddylee17 is offline Offline
Posting Pro

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

 
0
  #9
Oct 5th, 2008
Make the exe in Visual Studio. Access is a desktop database platform, not a software developing platform.
Lost time is never found again.
- Benjamin Franklin
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the MS Access and FileMaker Pro Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC