strange

  • Thread starter Thread starter Richard Douglass
  • Start date 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
 
you're sure that the connection opens ok and that the backed up db has
actually got the stored proc ?
 
Back
Top