Quote:
|
Originally Posted by skchakri
Hi,
I am getting the following error
-2147217900 Syntax error in INSERT INTO statement
while inserting and "It should be updateable query" error while updating the records of Access DB. I didnt get any problem in the retrievals...I am sure the Queries 100% correct.
I am updating using
ConnObject.execute SQLQuery
|
That's a permission problem. Make sure you give the ASP local username write privledges to the database.
__________________
Shane Bauer
Microsoft Certified Professional (MCP) - ASP.NET
ASP/ASP.net, C#, VB/VB.NET, PHP, Perl, SQL
|