Stand Alone Database

[Dave Allar]

I haven't used Access yet, but would like to know if an "application"
(table, forms, reports, etc.) can be compiled into a stand alone exe file.
One that can be used on a computer without Access.

Thanks for your help!

Dave

 

[Bob Loder]

Hi, Dave

I asked the same question about 2 weeks ago.

Unfortunately the answer is no. You would have to re-write the FE in a
different language C++, etc. I even researched a program or function to
"translate" my FE into another language to no avail.

I'll bet this question is asked alot! Wouldn't it be neat?

Good Luck!
Bob Loder
Tampa, FL

 

[Kevin3NF]

You cannot compile Access into a .exe, but you can package it up and
distribute it to run on computers that do not have Access installed.
Depending on your version, you need the Access Developer's toolkit, Office
Developer's edition, or Visual Studio tools for Office. This enable you to
include a "run-time" version of Access in your package, which allows the
users to run your application, but they cannot create their own, or modify
yours.

Hope that helps.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Dave Allar]

Kevin,

That's exactly what I'm looking for...

Thanks!
Dave

 

[Kevin3NF]

microsoft.public.access.devtoolkits

might be a good place to read up on these versions and ask questions as you
go forward. Glad I could help.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

 

[Larry Linson]

If you insist on an executable what you describe is correct. However, if you
just want to make your database application available to users who do not
have Access, you can distribute with the runtime support -- you will need
the Developer Edition of Access 2002 or earlier, or the Visual Studio Tools
for Office 2003 System (what a mouthful!) for Access 2003. The cost
difference between the Pro and Developer Editions is comparable to the price
of a compiler, and you can rely on this, you'll develop your app a lot
faster/easier in Access than in any flavor of C or VB or any other front-end
tool I can think of!

So, the purpose that would be served by an executable is already served.

Larry Linson
Microsoft Access MVP