JeanDenis
May 2nd, 2000, 12:04 AM
I'm a new programmer with VB, and I have a problem using the RecordSet on a Access database.
Here my code:
Dim DB as Database
Dim RS as RecordSet
Set DB = DBengine.OpenDatabase("C:\Product.mdb")
Set RS = DB.OpenRecordSet("GSproduct")
When I compile, I have a error message who tel me that I have a Incompatible Type on the sentence :
Set RS = DB.OpenRecordSet("GSproduct")
I think that VB does'nt recognize my table Gsproduct in my database Product.mdb. I built this Product.mdb in Access 97 wich contains few tables. I don't understand why VB can't see it, because when I use Control Data, I have no problem.
Jean-Denis
Here my code:
Dim DB as Database
Dim RS as RecordSet
Set DB = DBengine.OpenDatabase("C:\Product.mdb")
Set RS = DB.OpenRecordSet("GSproduct")
When I compile, I have a error message who tel me that I have a Incompatible Type on the sentence :
Set RS = DB.OpenRecordSet("GSproduct")
I think that VB does'nt recognize my table Gsproduct in my database Product.mdb. I built this Product.mdb in Access 97 wich contains few tables. I don't understand why VB can't see it, because when I use Control Data, I have no problem.
Jean-Denis