Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

AddNew (ADO)

Status
Not open for further replies.
elziko

elziko

Programmer
Nov 7, 2000
486
GB
I have a table with 105 text fields and a single dimensional array (rowarray) containing 105 string values.

I then try and use AddNew:

recmdb.AddNew , rowarray

However I am given an error which I dont seem to be able to understand:

Arguments are of the wrong type, are out of accpetable range or are in conflict with one another.

What sort of things can cause these problems? As stated above I have the same number of items in the array as fields in the table and everything is of string type.

Thanks

elziko
 
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Adobe SDK
Replies
6
Views
217
Swi
Swi
Swi
  • Locked
  • Question
Reading Tab Delimited File Using ADO 1
2
Replies
20
Views
518
Swi
Swi
Swi
  • Locked
  • Question
Works in Access but not through ADO
Replies
1
Views
92
Swi
Swi
jbradleyharris
  • Locked
  • Question
ADO connection string for Excel 1
Replies
5
Views
275
dilettante
dilettante
Andrzejek
  • Locked
  • Question
ADODB Filter with Date 1
Replies
17
Views
512
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top