Windows Forum

Ask something
Discussion Locked

Submit Key In a database

0 helpful
5 replies

by nijole

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I administer a webserver,I have created a site for a new client who's site needs forms and resumes filled out,when they submit it does not save to the database.I thought it was a problem with the html code but the webmaster says it has to do with mypermission setting in sql.I run sql7.0 and have given the neccesary permissions yet the problem is still there.Does anyone have any suggestions how this can be fixed in sql?

5 replies

by micxba

For the User, that you specify in the DSN connection to, you must have write permissions. Do not use the SA account for that just create a user wich has only write/change permissions for this table or the tables needed.

This discussion is closed to new replies.