ODBC -- call failed! Access to SQL Server at "Execute" - Microsoft Community

Thanks for replying. It's trying to execute a stored procedure. Does that make a difference? The insert statement in the stored procedure doesn't include inserting anything into the primary key because it's an autonumber field but so is the production db.

answers.microsoft.com