MS Access Problem

I am trying to link my asp pages in dreamweaver into MS access - can create
a registration page and login page OK, but then get into problem when trying
to add records - I get the following message

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
/flashy_ex_airpic/register_fulldetails.asp, line 116

So I then go to line 116 in the code and there is the following line -

MM_editCmd.Execute

Which is part of this block of code

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

Anyone who can help me I would really appreciate it

Check your field names .. you have a reserved word in there that is causing
the error. Common errors are things like "date" and "time" or using a - in
e-mail .


--
Nancy Gill
Team Macromedia Volunteer for Dreamweaver MX/UltraDev
http://www.macromedia.com/go/team/
BLOG: http://www.dmxwishes.com/blog.html
Co-Author: Dreamweaver MX Instant Troubleshooter (coming soon !)
Technical Editor: Mastering Macromedia Contribute
Technical Reviewer: Dynamic Dreamweaver MX/DMX: Advanced PHP Web Development

"rupbrown" <rupert (AT) madforit (DOT) co.uk> wrote

I am trying to link my asp pages in dreamweaver into MS access - can
create
a registration page and login page OK, but then get into problem when
trying
to add records - I get the following message

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
/flashy_ex_airpic/register_fulldetails.asp, line 116

So I then go to line 116 in the code and there is the following line -

MM_editCmd.Execute

Which is part of this block of code

If (Not MM_abortEdit) Then
' execute the insert
Set MM_editCmd = Server.CreateObject("ADODB.Command")
MM_editCmd.ActiveConnection = MM_editConnection
MM_editCmd.CommandText = MM_editQuery
MM_editCmd.Execute
MM_editCmd.ActiveConnection.Close

Anyone who can help me I would really appreciate it

Nancy - you are an absolute star! - I had the field town/city in the database - this seems to have cured the problem.

Once further question that you may be able to help me with - once I have created a page where people create themselves a user name and password - how can I then the link this to adding / amending their personal details - and their's only?

many thanks