Create EXE with Database code

[Jyoti]

Can anyone please guide me in creating standalone EXE file, that can be executed on any computer that does have VB installed. I have created a VB application that connects to the MS-Access database using the following code:

MyConnectionString = "Driver={Microsoft Access Driver (*.mdb)}; DBQ= " & databaseSrc
Set MyConnection = New ADODB.Connection
MyConnection.Open MyConnectionString

I also generated the EXE using the VB 6 File menu option. But, I cannot make it run on a computer that does not have VB installed.

An Early help is highly appriciated.
-------------------------------------------

Hi Clunietp ,

Thanks for your reply. I keep getting the following error mesage:

Error #430: Class doesn't support Automation or Does not provide the interface.

As suggested by Microsoft support site, I copied the following dlls to the Windows/System area, but I still keep getting the same error message. I am really getting frustrated with this error message.

---------------------
What following table lists the size, date, and version of the run time and OLE Automation files that shipped with Microsoft Visual Basic 6.0:


File Version Size Date
---- ------- ---- ----
Oleaut32.dll 2.30.4261 585KB 6/18/98
Olepro32.dll 5.0.4261 161KB 6/18/98
Stdole2.tlb 2.30.4261 18KB 6/17/98
ASYCFILT.DLL 2.30.4261 145KB 6/18/98
Msvbvm60.dll 6.00.8176 1,376KB 6/18/98





[Edited by Jyoti on 07-02-2000 at 10:36 AM]

[Clunietp]

Odds are is that it is an installation issue. What errors are you getting on the client?

use PDW (or another installation tool) to distribute your application.

If you have troubles on machines, that have VB6 installed, the reason for that is probably a different ADO version (you compiled your exe with ADO 2.5, the other machine has ADO 2.1 installed).

good luck

Sascha