PDA

View Full Version : Solved: ADO error: syntax error or access violation



DBinPhilly
06-19-2011, 03:45 AM
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.