i want to make my finished database to execute alone w/out access

[jetro=)]

how can i make my finished database to run alone what i mean is to be a
standalone program without opening my access but i dont know how =(, in C++
it is easy to compile and make it executable and even in VB we can make exe.
form and can be easily compile but in access i try it all but i didnt get it
right can u help me plz!

 

[Fred Boer]

Dear Jetro:

You can't. You need to have Access installed, or have the runtime version of
Access installed. You can't compile an Access application to an .exe.

HTH
Fred Boer

 

[Pat Hartman\(MVP\)]

An Access database file is a container for other files. It contains tables
with application data and other tables with object definition data. It is
not possible to compile this type of file. Either the retail version of
Access or the runtime version is required to be installed on any PC that
needs to run your application.

You can purchase the Visual Studio Tools for the Microsoft Office System
($700) which includes the packaging and deployment wizard that lets you
create a professional installation package to install your application and
any necessary ancillary files. The tool also lets you distribute a royalty
free license for the MSAccess.exe which is needed to run your application.
The tools can distribute unlimited copies of a single application or
multiple applications. There are no number limits.

 

[jetro=)]

can i used my Visual studio as a subtitute we all know that Access uses
VBcode so cant we used it? duh office tools are expensive and i do not have a
budget but i think there is a way to modify it.

 

[jetro=)]

im looking for another way to make this dbase run without a access, if only i
can find that right code i think theres another way.

 

[Pat Hartman\(MVP\)]

As a substitute for what? The standard VS product does NOT come with the
Access runtime license. Only the "tools" product does.

The "tools" product doesn't do anything to your database. It only gives you
a license to distribute the MSAccess.exe along with your .mdb.

 

[Pat Hartman\(MVP\)]

There is no other way. To run an Access database, you MUST have the correct
version (retail or runtime) of MS Access installed.

 

[jetro=)]

yes you are right there is no way i can make a standalone application, but i
got this sample and i tried it and it works but it only remove some access
command and icons. by using runtime command and i create a shortcut icon and
then copy it to target

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /runtime
"C:\Documents and Settings\Accpac\My Documents\Expense report database.mdb"

 

[Douglas J Steele]

But that shortcut requires that Access exist on the workstation!