Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-11-07 : 09:25:56
|
| Dan writes "I know you concentrate on SQL Server and repudiate Access queries, but since you actually have a good Access section, I'll chance this question here.I'm trying to insert a single row into an Access 97 table from a VB program. The SQL I execute is:INSERT INTO t_problem (appID, date, brief_desc, fix) VALUES (1, #11/06/2002#, "xxx", "yyy")and I always get the error "Syntax error in INSERT INTO statement."I've tried with numerous combinations of single/double quotes, empty strings, NULLs, but get the exact same error every time.I searched your Access forum and found pretty much the same problem from a post of a couple of years ago, but no one could provide a definitive solution.Thanks in advance to anyone who can shed some light!" |
|
|
borstalboy
Starting Member
4 Posts |
Posted - 2002-11-07 : 10:09:05
|
| The problem, of course, was that "date" is a reserved word. Access lets you create a table with a column called "date", but you can't refer to it directly in a SQL statement like this. |
 |
|
|
|
|
|
|
|
Access - INSERT INTO Syntax error