By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,219 Members | 2,242 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,219 IT Pros & Developers. It's quick & easy.

SQL error with Access DB

P: n/a
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
Nov 17 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

"Warex" <Ig************@juno.comschreef in bericht
news:%2****************@TK2MSFTNGP04.phx.gbl...
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

Nov 18 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.