-
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]
-
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
