Create an .exe file from an Access .mdb file

[TimT]

Can anyone direct me towards a solution to convert an .mdb file into an .exe
file that will run on any PC machine even if it does not have Access
installed on it?
I thought Access had the capability to convert a file into a standalone
program.
Please advise. )

 

[Dirk Goldgar]

Can anyone direct me towards a solution to convert an .mdb file into
an .exe file that will run on any PC machine even if it does not have
Access installed on it?
I thought Access had the capability to convert a file into a
standalone program.
Please advise. )

Alas, you were mistaken. If you buy the appropriate Developers Edition
or Developer Tools, you can package your .mdb or .mde file with an
Access runtime module -- essentially Access with all menus and
user-interface removed -- but that's the closest you can come.

 

[Jeff Conrad]

in message:

Can anyone direct me towards a solution to convert an .mdb file into an .exe
file that will run on any PC machine even if it does not have Access
installed on it?
I thought Access had the capability to convert a file into a standalone
program.
Please advise. )

Short answer is "no."

Access needs Access to run so to speak.
Here is a past post by MVP Doug Steele which should really help:
You can purchase the Developer Edition of Office*. That allows you to
package your application together with a royalty-free run-time version of
Access that your users can install so that they can use your application.

*Actually, the name is constantly changing.Tony Toews has an overview at
http://www.granite.ab.ca/access/developereditionfaq.htm that should help you
figure out what you need.

http://www.granite.ab.ca/access/developereditionversions.htm

http://www.granite.ab.ca/access/developereditionfaq.htm

Be aware, though, that Microsoft only sells the most recent version of
Office. With Office 2003, that means you need to purchase the following in
order to create an Access 2003 runtime application:

- Microsoft Access 2003
- Visual Studio Tools for Office 2003 (which includes the Access 2003
Developer Extensions)

The ADE is the product that gives you the license to deploy the 2003 runtime
components and you have to have Access 2003 installed in order to install
the ADE.

http://msdn.microsoft.com/office/technologyinfo/devtools/accessextensions/default.aspx
[/QUOTE][/QUOTE][/QUOTE]

Hope that helps,

 

[TimT]

Thanks all!

in message:


Short answer is "no."

Access needs Access to run so to speak.
Here is a past post by MVP Doug Steele which should really help:

You can purchase the Developer Edition of Office*. That allows you to
package your application together with a royalty-free run-time version of
Access that your users can install so that they can use your application.

*Actually, the name is constantly changing.Tony Toews has an overview at
http://www.granite.ab.ca/access/developereditionfaq.htm that should help you
figure out what you need.

http://www.granite.ab.ca/access/developereditionversions.htm

http://www.granite.ab.ca/access/developereditionfaq.htm

Be aware, though, that Microsoft only sells the most recent version of
Office. With Office 2003, that means you need to purchase the following in
order to create an Access 2003 runtime application:

- Microsoft Access 2003
- Visual Studio Tools for Office 2003 (which includes the Access 2003
Developer Extensions)

The ADE is the product that gives you the license to deploy the 2003 runtime
components and you have to have Access 2003 installed in order to install
the ADE.

http://msdn.microsoft.com/office/technologyinfo/devtools/accessextensions/default.aspx

[/QUOTE]

Hope that helps,[/QUOTE]

 

[Jeff Conrad]

in message:

Thanks all!

You're welcome, glad to help.
Good luck with your project.