Can't Create Linked Server SP in ADP

[Neil]

I created a stored procedure to update a table on a linked server from a
table in my local server. Both servers are SQL 7, and the linked server is
accessed through the Internet. When I tried to create the stored procedure
using an Access 2000 ADP file, the save command would continually time out.
However, when I went into Enterprise Manager and created the stored
procedure there, it saved instantly. Once the SP was saved, it could be run
from the ADP file without any problem. But neither creating nor modifying
the SP would work through the ADP file.

Any ideas on why the ADP file would not be able to create or modify the SP,
but would be able to run it, or any ideas about what might be able to be set
in the ADP file to enable it?

Thanks!

 

[aaron.kempf]

you got your Access 2000 patched to the latest service pack?

ps - are you using the 'create proc' syntax to make the sproc?
you need to spell out 'procedure' and not abbreviate

i swear i would beat the living crap out of an Access PM if i found
one. i mean how in the heck do they sit there with their rolex; their
stock options and their bmw-- they sit there any miss a bug like that?

they should retroactively be terminated and or shot on site.

dipshits running the show in redmond.