strange

  • Thread starter Richard Douglass
  • Start date
R

Richard Douglass

I have an Excel sheet with a VBA SQL connection routine. When I run the app
on one database it works fine. If I run it on a backup of the same database
it crashes on the EXEC <proc> statement and says incorrect syntax near EXEC
statement.

Why would it work fine on one DB and not on another? I am using the admin
account for both.

Help!

Thanks
Richard
 
P

Patrick Molloy

you're sure that the connection opens ok and that the backed up db has
actually got the stored proc ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Execute SQL Stored Proc from Access 1
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
return multiple results from stored proc 1
VBA error while using SQL "with rollup" 2
non basic code in call stack 3
Creating a query to select 1 of 3 tables 3
Calling Parameterized Query Using SQL Syntax 3
32/64 bit access to access? 0

Top