access executables

[xarrisx]

I have created an access mdb with tables forms etc...

What are the diffrent ways to make my database executable (no need for MS
ACCESS installed on system).
I want it to open a defined form when it opens ( but not under MS ACCESS).
It must be a standalone application.

something like the "Tools->start" option but standalone. Do i have to use
vb/vc++.

Please any info or links are welcome.

 

[Nick Coe \(UK\)]

You need the Developers version of Office for your version
of Access. That allows you to create distributable install
packages that include an Access runtime.

You cannot make Access app's into executables.

In addition I would advise making your app front end an MDE
rather than an MDB file.

 

[John Vinson]

I have created an access mdb with tables forms etc...

What are the diffrent ways to make my database executable (no need for MS
ACCESS installed on system).

There are none. The program is not capable of creating such an
executable.

I want it to open a defined form when it opens ( but not under MS ACCESS).
It must be a standalone application.

something like the "Tools->start" option but standalone. Do i have to use
vb/vc++.

Two options:

- Purchase the version of the Access Developer's Toolkit for your
version of Access. They keep changing the name - now it's Visual
Studio Tools for Microsoft Office:

http://support.microsoft.com/kb/828087

This will let you create a royalty-free "runtime" version of the
Access program which you can distribute with your database.

- Or, reprogram your entire application in Visual Basic or VC++ or
VS-Net. This will require redoing all your forms and reports from
scratch; the Access structures use their own data model that doesn't
export well (or at all).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[jine]

I have created an access mdb with tables forms etc...

What are the diffrent ways to make my database executable (no need for MS
ACCESS installed on system).
I want it to open a defined form when it opens ( but not under MS ACCESS).
It must be a standalone application.

something like the "Tools->start" option but standalone. Do i have to use
vb/vc++.

Please any info or links are welcome.