Error in Insert statement

[eimroda]

I used PWS (win98 ) in testing my asp scripts in my pc and everything was going alright. I uploaded my asp scripts to brinkster.com and even before I uploaded them and used IIS, I was getting a SYNTAX ERROR in INSERT statements (sql) when adding a new record to a table which has an autonumber field (I got no problem with tables without an autonumber field). I tried to use the syntax RS.AddNew but the error I got was "Provider does not support this action" (something like that) . I am confused since with PWS, using the same script, everything was fine. Please help me... By the way I am using Microsoft Access fo rmy database.

[monte96]

Um... post the insert statement...

[eimroda]

OK, tnx for your time, here it is:

SQLStmt = "INSERT INTO users "
SQLStmt = SQLStmt & "(UserName, PassWord, Name, Course, School, email, DateRegistered)"
SQLStmt = SQLStmt & "VALUES('" & vUserName & "','" & vPword1 & "','" & vName & "', '" & vCourse & "', '" & vSchool & "', '" & vEmail & "', '" & vDate & "')"

Set RS = Connection.Execute(SQLStmt)

[Jeh]

With ms access, shouldn't you surroud dates with ## not ' '?, don't know if that's the problem, bu might be worth a try.

[Radames]

Let me see your connection string please

[eimroda]

ok here it is:

ConnectStr = "Provider=Microsoft.Jet.OLEDB.4.0;"
ConnectStr = ConnectStr & "Data Source=" & Server.MapPath("/eimroda/db/data.mdb") & ";"
With Connection
.ConnectionTimeout = 15
.CommandTimeout = 30
.ConnectionString = ConnectStr
.Open
End With