using access as a front end, building a stand alone exe

[Ted Sung]

Hi,

We are moving to using mysql as our db and we have some reports
already written in Access. Is there a way to create a stand alone EXE
that will run the report from Access and then use a DSN and have our
DSN point to the mysql db instead of using Access's db? We don't want
to have to install Access on everyone's machine in order to run the
report.

Thanks,

Ted

[Salad]

Ted Sung wrote:

Hi,

We are moving to using mysql as our db and we have some reports
already written in Access. Is there a way to create a stand alone EXE
that will run the report from Access and then use a DSN and have our
DSN point to the mysql db instead of using Access's db? We don't want
to have to install Access on everyone's machine in order to run the
report.

Thanks,

Ted

The Developers Kit, or some similar name, can create RUNTIME versions.
You can't create an EXE.

The Developers Kit may be hard to find if you are looking for any
version but AXP or A2003. It will set you back several hundred dollars
but if you are looking for a run time version that will be the method
you want to use.