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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linq to sql Delete 2
displaying the sql commands generated by commandbuilder? 1
VB / Access / SQL syntax problem 2
reserved word for DB column name crashes data adapter update 17
SYNTAX FOR REFERENCING SQL PARAMETER QUERIES 2
Problem importing Date Field into SQL DB. 3
Syntax error on SQL INSERT 5
Syntax error in INSERT INTO statement 4

Back
Top