Printable View
I'm trying to use the command object 'OLEDbCommand' but each time I type in the syntax I get the error 'User-defined type not defined'
Can someone tell my why VB is doing this? Do I need to add a componet and if so which one?
Here's the syntax I'm using:
Dim cmd As New OleDbCammand(InsertString, OleConn).
OLEDbCommand is part of .Net, so is not supported by VB6 - instead you should be using an ADODB.Command
To be able to use it you need a reference to "Microsoft ActiveX Data Objects Library X.X", and the kind of code shown in "method 3" of the article How can I add a record to a database? from our Database Development FAQs/Tutorials (at the top of the Database Development forum)
That would explain it. Thanks for you help...:thumb: