No Update Permissions

[stevelibby]

i have tried to follows what has been done below, but get:

No Update Permissions!

What does this mean? Any ideas

[w3schools.com...]

[Easy_Coder]

Are you attempting to update an Access Database that exists on the web server? If the answer is yes then you need to have your host set permissions on the directory where your database is sitting so that you can Add, Update & Delete...

[stevelibby]

it is an ms sql database!

[TheNige]

then your sql login needs to have update permissions on the table that you are trying to update.

But looking at that example...that error message is what they are writing out...not SQL Server. You could comment out the On Error Resume Next to view the real error that you are getting.