Access 2000 copy stored procedures

[TonyScott]

I am running Access 2000 and deploying using MSDE.

I have made changes to the stored procedures on my machine and now want to copy those changes into the original database on the users machine.

Is there any way I can do this without manually typing it in ?

 

[cmmrfrds]

Do you have enterprise manager? If so, you can create the script and then run the script on the other PC.

The SP code is stored in syscomments. You can use a query like this to bring back the text.

Select so.name, sc.text from sysobjects so
inner join syscomments sc on so.id = sc.id
where so.xtype = 'P'

 

[cmmrfrds]

Do you have enterprise manager? If so, you can create the script and then run the script on the other PC.

The SP code is stored in syscomments. You can use a query like this to bring back the text.

Select so.name, sc.text from sysobjects so
inner join syscomments sc on so.id = sc.id
where so.xtype = 'P'

I am sure you can figure the different ways to extract the text from the query.