MS Access Problem

[rupbrown]

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 Gill]

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
[url]http://www.macromedia.com/go/team/[/url]
BLOG: [url]http://www.dmxwishes.com/blog.html[/url]
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@madforit.co.uk> wrote in message
news:bf8qjr$oo7$1@forums.macromedia.com...

> 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
>
>

[rupbrown webforumsuser@macromedia.com]

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

[Unregistered]

Grear answer, worked a charm!

[Unregistered]

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
[url]http://www.macromedia.com/go/team/[/url]
BLOG: [url]http://www.dmxwishes.com/blog.html[/url]
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@madforit.co.uk> wrote in message
news:bf8qjr$oo7$1@forums.macromedia.com...
create
trying

--------------------------------dreamweaver Help----------------
u go at Tag area(i.e. right side)
presss "+" in database tab
give name of new connection e.g. connection1
write string : "provider=Microsoft.jet.oledb.4.0;data source=c:\Inetpub\wwwroot\cms\xxx.mdb;"