-
Solved: ADO error: syntax error or access violation
I am writing an MS Access 2010 project. I have SQL Server 2008 Developer's Edition.
I created two stored procedures that passed the "Verify SQL Syntax" button. But when I attempted to make a third similar procedure, suddenly none of them will pass the "Verify SQL Syntax" button and they cannot be saved. I get the error message: ADO error: syntax error or access violation
I've tried giving full permissions to each Stored Procedure on the SQL Server side. I've done the same with each SQL table involved.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules