Using an Access database on a machine that does't have Access installed ...

[DT]

Is this possible? Do I need to convert to a different file type? Maybe exe
file and if so how would I go about doing that please?

Many thanks.

 

[Joseph Meehan]

Is this possible? Do I need to convert to a different file type?
Maybe exe file and if so how would I go about doing that please?

Many thanks.

You need MS Access to run an Access database. Access does make a
Developer's version that allows you to create an Access database that you
can distribute free that can be used on different machines at no additional
charge.

You can save your MS Access data (but not forms, reports or queries) in
various forms like Text that can be read by other programs.

If you can tell us more about what you want to do we may be able to
help.

 

[Douglas J. Steele]

It is not possible to convert an Access application into an executable.

Realistically, there you have 3 options.

1) Rewrite your application in a language that can be compiled into an
executable such as VB or VC++ (note that your data will still have to be
kept in an external MDB file)

2) Rewrite your application as a web app

3) Get the Access Developer edition that's appropriate for whatever version
of Access you're using (see
http://www.granite.ab.ca/access/developereditionversions.htm for details of
what you need to look for) What this allows you to do is package your
application together with a royalty-free run-time version of Access. Users
who don't have Access installed will be able to install the run-time and use
your application. They will not be able to make design changes to your
application (nor to any other MDB)

 

[Trey]

There is also a MS Access runtime you can get to run the database.

 

[Douglas J. Steele]

That was point 3 in my response...

 

[Trey]

That was point 3 in my response...

Ahh, sorry, didn't see that part.

 

[Steve Merkley]

There are a few programs that claim to be able to convert Microsoft Access
databases to various other formats, including VB projects (which can, of
course then be compiled to .exe files, provided you own a copy of Visual
Basic/Visual Studio.)

A quick summary can be found here:
http://www.granite.ab.ca/access/accesstovb.htm.

However, as the page will warn you, these tools have been known to not be
able to convert some aspects of the user interface perfectly: "your mileage
will vary."

Regards,

Steve Merkley