Question Publish an ADP project as an .exe

[scheeps]

Is it possible to publish an ADP project as an executable to run as a standalone application without an Access installation?

 

[pbaldy]

No, it's not. You can use the runtime version of Access; versions since 2007 have been available free from Microsoft.

 

[scheeps]

Paul, do you know how I can publish my .adp project file?

The only options available under "Save & Publish" are Access 2000 mdb, Access 2002-2003 mdb and Make ADE.

If I click the ADE option (which Access states is the executable only file) then I get instantly get a "MS Access was unable to create an ADE Database" error.

Microsoft suggest in this post http://support.microsoft.com/kb/283788 that you need to remove any references to .mdb and .adp files.

My .adp only reference SQL Server tables - not sure if the above suggestion refers to physical .adp files or only reference to .adp projects.

Any suggestions?

 

[pbaldy]

The usual suspect in my experience is code that won't compile. Have you compiled yours?

 

[scheeps]

Probably a stupid question, but how would I go about in compiling my VBA code?

That is something I've never done before.

 

[Galaxiom]

First item in the Debug menu of the VB Editor is Compile.

It will stop with an error if it doesn't like something in your code.

 

[scheeps]

Mmmm, looks like there are some things it do not like in my code. Thanks for your help.