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