sSQL = "INSERT INTO..... Syntax Error

[UnfitElf]

Yes about that date thing i have set it to text as i thought that could be what was going wrong... BUT it still goes wrong

Any more ideas??

Thanks for your help...

[yasserhy]

try this:

instead of using the regular connection varbiable:

dbPath = Server.MapPath("datasource.mdb")
dbConnection.Provider = "Microsoft.Jet.OLEDB.4.0"
dbConnection.Open dbPath

you can use one of the following:

1. dbPath = Server.MapPath("datasource.mdb")
dbConnection.Provider = "Microsoft Access Driver (*.mdb)"
dbConnection.Open dbPath

2. dbPath = Server.MapPath("datasource.mdb")
dbConnection.ConnectionString= "Driver={Microsoft Access Driver (*.mdb)};DSN=;DBQ=" & dbPath
dbConnection.Open

[Frank]

Do a debug dump of the SQL. Cut and paste the statement and go to the DB query or enterprise manager and execute the statement. All the missing quotes and invalid syntax will show.

Fk