Creating a stand alone application in Access

[TheKidLarose]

Does anyone know if you can create a stand alone application with mdb files created using Access?

tks

Denis Larose

 

[Norris68]

No. The closest you can get is to install the freely-distributable Access run-time - available with the Developer edition. This is slightly limited in functionality (e.g. filter by form function does not work). The installation of the run-time is built in to your setup if you use the Access PDW (again supplied with Developer edition)

You will not be able to produce an EXE file from an Access database.

 

[TheKidLarose]

Can you create an exe file using Visual Basic 6.0 and use the forms or tables built with Access 2000.

tks

Denis

 

[Norris68]

You mean using automation? Yes, but you will need Access installed on the target system.

You cannot 'import' an Access project into VB6. Although the non-Access specific code will work, the forms & controls are completely different. For instance, there is no VB equivalent of the sub form (although it is possible to a certain extent using API calls).