Compiling stand alone EXE?

[Mark03]

Hi,

I have completed making a database in MS Access. All forms, queries,
macros, etc are complete.

Was wondering how you can compile a stand-alone EXE file so that you
dont need to open Access every time?

I remember my teacher said it can be done some how.

Any info, thanks

Mark

 

[dt01pqt_pt]

You can create the forms in a Visual basic program, which can access a
database. A good VB book would tell you how to do this. You can also
set it up so when you click on the desired forms load automatically and
various other settings. Depending on what you want the user the
experience there is a developmental, or standalone solution. I would
tend to stick to simple programming as I'm new to access and settings
(and data basing).
Just my 20 pence worth.

 

[Larry Linson]

I have completed making a
database in MS Access. All
forms, queries, macros, etc
are complete.

Was wondering how you can
compile a stand-alone EXE file
so that you dont need to open
Access every time?

I remember my teacher said it
can be done some how.

If so, I regret to say that your teacher was wrong. You can, if you license
the Office Developer Edition for the version of Access that you want,
package Access with runtime support so the user does not have to have Access
installed.

However, if you have created your application with macros, which do not have
error handling capabilities like VBA code, any error will rather
unceremoniously dump the user out of the database.

I'll say this, however, it'll be a lot easier to learn enough VBA to convert
your macros and get the Developer Edition (the Visual Studio Tools for
Microsoft Office 2003 System, for Access 2003) than to take the other advice
and reimplement the application in VB with a Jet database. (My credentials
on that subject are that I've used both VB and Access since their respective
Version 1's.)

Larry Linson
Microsoft Access MVP