ADO AddNew not working

[robulator]

I'm trying to add a new record to a database using the AddNew method of a recordset within an asp page. The browser error message that I get says "Object or provider is not capable of performing requested operation." I can establish a connection with the database (I've tried both Access and SQL Server) and I can view records, I just can't add new ones.

If anyone has any suggestions, I'd sure appreciate it.

Rob

 

[asptim]

Let's see the code? Only way to tell.. Usually, but not always it's one of the two in my experience..

Database fields are not the same name as the fields in your code.. So you've mispelled something.. Check that very good..
Next insure you have the correct database, table name, etc..and are using the correct cursor, etc..
Check that the permissions are correct on the folder with the database.. if your using access.. Make sure all permissions are correct and that you are allowed to update the table your supposed to be adding information to!

Hope that helps.
Tim

 

[mrichards]

Try using an "insert into query" that should solve your problem.

Mark