SQL error with Access DB

  • Thread starter Thread starter Warex
  • Start date Start date
W

Warex

Hello,

I am slowly gaining ground eroor by error.

what does error in sql syntax with insert mean? and what do I look for? how?

I set up my primary key and the commandbuilder.

According to the MS docs, the command builder creates all the syntax for
insert delete update commands.
but seemingly this is not true... Any suggestions
 
Warex,

As long as your select statement is complete and you do not use more than
100 fields, without a key the commandbuilder can by instance do nothing,

Cor
 
Back
Top