Compiler

[Peter Marshall]

Is there a compiler available for Access applications, specifically for
Access 2003/2007?

 

[boblarson]

I would be interested in what you are really asking for, but the compiler for
Access (all versions) is built-in to the program and is available when you
are in the code window by going to DEBUG > COMPILE xxx.

There is no external compiler and doesn't need to be. If you are asking if
you can make it an exe file, the answer is no. You can use the Access
runtime and the developer extensions to create an installation package which
will install the Access runtime so that anyone without Access can use the
database, but you can't create an exe file like a VB6, VB.NET, C#, C++
program, etc.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[Pat Hartman]

There is no compiler for VBA. It is an interpreted language that is
"compiled" as it is executed. There is an option in the VBA window to
"compile" the database but that produces what is called p-code which is more
like a semi-compiled state.

If your question is really - Is there a way to distribute an Access
application as an executable, the answer is no. You will need to have
Access (full or runtime) installed on any PC that needs to run your
application. The developer's tools for 2007 can be downloaded for free from
the MS site. This will enable you to create a distribution package that
does an install of your application on the client PC either with or without
including the Access Runtime engine.

 

[Peter Marshall]

Thank you both for your quick responses. Yes, I was asking about a compiler
in order to create an exe that could be run without MS Access. I will check
into the Access Runtime that you both mentioned. Thanks!

Peter Marshall
Manager Information Services
Ohio Coatings Company

 

[Tony Toews [MVP]]

Thank you both for your quick responses. Yes, I was asking about a compiler
in order to create an exe that could be run without MS Access. I will check
into the Access Runtime that you both mentioned. Thanks!

Also see Microsoft Access (Office) Developer Edition FAQ
http://www.granite.ab.ca/access/developereditionfaq.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[sandwich]

Also see Microsoft Access (Office) Developer Edition FAQ
http://www.granite.ab.ca/access/developereditionfaq.htm

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Alpha 5 can do the same things as access plus you can create an exe and have
the look and feel of any other program!

http://alphasoftware.blogspot.com/2007/02/alpha-five-and-quest-to-conquer.html