I am using the following code in order to create a new table and then add some fields to the table, then I plan tao populate it with an append query.
I keep getting, an
"Run-time error '3290':
Syntax error in CREATE TABLE statement."
message. When I click on the "Debug" button, it highlights the " db.Execute strSQL" line. This procedure was followed straight out of an Access 2000 book. Can anyone tell me what I need to do to get it to work?
Thank you in advance for your help!
Glen
Dim db As Database
Set db = CurrentDb
Dim strSQL As String
strSQL = "CREATE TABLE tbl_Addl_Info "
strSQL = strSQL & "(Ref_ID text(255), Addl_Acct_Nos text(255)," _
& " Addl_PIDs text(255), Addl_Legals text(255)," _
& " Addl_ECUs text(255), Addl_TADMaps text(255);"
db.Execute strSQL
RefreshDatabaseWindow
I keep getting, an
"Run-time error '3290':
Syntax error in CREATE TABLE statement."
message. When I click on the "Debug" button, it highlights the " db.Execute strSQL" line. This procedure was followed straight out of an Access 2000 book. Can anyone tell me what I need to do to get it to work?
Thank you in advance for your help!
Glen
Dim db As Database
Set db = CurrentDb
Dim strSQL As String
strSQL = "CREATE TABLE tbl_Addl_Info "
strSQL = strSQL & "(Ref_ID text(255), Addl_Acct_Nos text(255)," _
& " Addl_PIDs text(255), Addl_Legals text(255)," _
& " Addl_ECUs text(255), Addl_TADMaps text(255);"
db.Execute strSQL
RefreshDatabaseWindow