How to change the Thank You page INSERT INTO statement using ASP?

Dear EE experts,

We would like to ask for tech support on how to revise the attached scripts, before, the db that was used is mysql, then we're changing it to MS Access db. Please see the attached script & db as well (css_users.mdb).
The table name is Users.
We also would like to have not just a Thank You result, but to have user's firstname & lastname...

Thank you!

*** This would be related to our Registration Form page, that we'll open for another thread, diffrerent issue.

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Looks like pritamdutt showed you how to change the connection string to work with your Access database. If you need a little more assistance with that syntax, check this site: http://www.connectionstrings.com/access

In most cases, however, you'll need to use Server.MapPath(myDb) to get the full path to the database on that server:

As you can see, you're not supplying anything to the VALUES section of your insert statement. This may or may not succeed, depending on what restrictions you have set on the table and fields.

As pritamdutt said, try running that INSERT statement directly in your Access database. To do that, open the Access database, create a new Query but don't add any tables, then switch over to SQL view. Copy/paste the INSERT Statement into that SQL view, then swith over to Design view. If there is trouble, the Acess query engine will complain.

0

Stiebel EltronAuthor Commented: 2011-10-07

I'll get back to you on Monday, asap....

0

Stiebel EltronAuthor Commented: 2011-10-09

@LSMConsulting: As per your response to this thread ID: 36932611, I did what you said, I didn't receive any errors... but I still receive this error, tried to fill up forms and send.
INSERT INTO Users (Name,Surname,Email,Password,RePassword,Country,Telephone,Mobile,Company,Address) VALUES ('da','da','da','da','da','da','da','12','12','da')
Microsoft VBScript runtime error '800a01a8'