strange
 

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

strange
 

hi
post the excute statement. and any other code too.l

Regards
FSt1

"Richard Douglass" wrote:

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

strange
 

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

"Richard Douglass" wrote in message
...
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