You need to set the provider as a datashape:
db.Open "Provider=MSDATASHAPE; Data Provider=Microsoft.JET.OLEDB.4.0;" & _
"Data Source=C:\VB\test dbase.mdb;"
Dear Reader-
I've created a datareport in VB6 without using the data environment. There is one grouping level, achieved using the SHAPE command. (Code below)
Unfortunately, the shape command does not seem to work in this situation. I get the following error…
Run-time error ‘-2147217900...
Mark-
I had a simmilar project. Here is the code I used to connect.
On Error GoTo GetData_Err
Dim db As Connection, strvar As String
Dim dbcmd As Command, rst As Recordset
Dim db2 As Connection
Dim dbcmd2 As Command, rst2 As Recordset
Dim intMark As Integer
Dim intDia As Integer
Dim intSys As...
Dear Reader-
I've created a datareport in VB6 without using the data environment. There is one grouping level, achieved using the SHAPE command. (Code below)
Unfortunately, the shape command does not seem to work in this situation. I get the following error…
Run-time error ‘-2147217900...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.