Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help: Strange, Strange Behavior ( Not Me. My Model! ) | Excel Programming | |||
strange... | Excel Programming | |||
Strange?! | Excel Discussion (Misc queries) | |||
Strange one | Excel Programming | |||
Very-2 strange | Excel Discussion (Misc queries) |