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!

ADO rs.Update

Status
Not open for further replies.
NevG

NevG

Programmer
Oct 10, 2000
162
GB
Hi

Can someone tell me why suddenly Im getting a

'Too many records Affected '

error from VB when I try to update a table / record in a SQL Server dbase.

there are 2049 records in the dbase but surely this is not extremely high. Access could handle it easy enough.

Any ideas anybody
 
Sort by date Sort by votes
Hi,
I think you have duplicate data in the table. I got this once.
Try to look into the data, you should be having duplicate rows.

 
Upvote 0 Downvote
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
529
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
284
dilettante
dilettante
Andrzejek
  • Locked
  • Question
ADODB Filter with Date 1
Replies
17
Views
519
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top