I am looking for a compiler ( I think) 1

[MHadden]

I have heard of a program called a compiler that you can use to create a stand alone program from an Access database I think it converts it to a vb program. This would work better for me than the current method of installing the run time files, then the database. Can anyone point me in the right direction, even if you could just tell me the name of such a program it would be helpful. Thanks in advance, Michael Michael
MichaelHadden@Home.Com
If you give someone a fish, you have given them a meal. If you teach someone to fish, you have given them MANY meals!

 

[JJOHNS]

You can by the developer version of Access. It will let you create stand alone applications.

 

[JamesMeadlock]

There is no program that'll create an executable from any access database. It sounds like you're using Access Developer to install the free Access Runtime client on machines.

Basically, keep on doing what you're doing or re-do the whole thing in VB.

 

[UncleJack]

A compiler is a program that creates machine language from a high level language. A cross-compiler is one that translates one high level language to another. As James states, there is no such cross compiler for Access nor is there ever likely to be one given the almost infinite variations possible within Access.

Uncle Jack

 

[MHadden]

My Ex-Brother - in - law has a program that will do this, I have seen it in action, but I just can't remember the name & can't contact him. If anyone is interested, I will let Y'all know the name when / if I can find out. Thanks for everyone's help anyway.
- Michael Michael
MichaelHadden@Home.Com
If you give someone a fish, you have given them a meal. If you teach someone to fish, you have given them MANY meals!

 

[Quing]

Hi,

I am interested in this compiler that your ex-brother-in-law might have. Kindly let me know also if / when you get a copy.

Thanks.


Sincerely,

Quing

 

[scking]

I'm skeptical about a compiler for Access. First of all, Microsoft would never license that capability to anyone so it probably couldn't be a third party tool. Then, I'm pretty familiar with Access capabilities having done this exclusively for about 5 years. Could your Brother-in-law be creating an MDE file from and Access MDB file. I've heard some mention it as an executable, which it really isn't. This confusion is sometimes compounded by the 'Compile' command in Access. It does not compile the
application into machine executable code like a compiler but mostly performs a syntax check and stores it in an intemediate state that is still intepreted.

Steve King Growth follows a healthy professional curiosity

 

[MHadden]

My Brother in law said it was Visual Basic Enterprise suite which cost him about 1500.00 then he went on the website & downloaded a "Library file" that enabled him to do that. This $ is too steep for me so I asked another programmer friend of mine who turned me on to a shareware converter for 99.95 You can access it at this link

http://www3.telus.net/lennox/objconv.htm

I haven't had time to try it out yet, but here's the info. in case it's helpful to anyone else out there. - Michael Michael
MichaelHadden@Home.Com
If you give someone a fish, you have given them a meal. If you teach someone to fish, you have given them MANY meals!

 

[tlbroadbent]

Michael,

The tool you provided the for is a converter not a compiler. It "converts Access Forms and Code, Controls (including ActiveX Custom Controls), Macros, Code and Class Modules to Visual Basic Forms, Modules and Projects." What you get is a VB front end to an Access database. The tool is obviously very handy but it doesn't create a stand-alone executable from an Access database.

I doubt the more expensive VB suite does much more than this tool. Certainly it cannot create an executable program from an Access database. It might convert and even compile those programmed objects and modules but the data must still be stored in a database.

Here are some additional links to converters for anyone who is interested.

Access to Visual Basic Object Converter

http://www.iriesoftware.com/

(The company that makes tool found at the link you provided.)

Access Converter, VB Edition

http://www.diamondedge.com/products/Convert-Access-to-VB.html

Access Converter, Java Edition

http://www.diamondedge.com/products/Convert-Access-to-Java.html

Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[JimHorton]

Any info on how this 'converter' deals with Access' nested subforms or multi-column combo-boxes?
--Jim

 

[MHadden]

Terry,
Thanks, this is very helpful information! I appreciate you taking the time to respond in so much detail.
Thanks,
Michael MichaelHadden@AltaVista.Com
If you give someone a fish, you have given them a meal. If you teach someone to fish, you have given them MANY meals!