Access Stored Procedures Template - CREATE PROC

[kparker]

How can I run the CREATE PROC scripts generated by the \"Access Stored Procedures\" template via code?

I need to be able to update the \"active\" database with the new or modified proc's.

Do I just open a oledb.connection and do an execute scalar with the \"CREATE PROC proc_.................\"?

Thanks.....

[mike.griffin]

There is a checkbox on the template itself, it automatically creates them in the database, I think the only way to get access stored procs into a database is through code. So if you can do it through code then you can do it through MyGeneration is my point, either way you're going to have to connect with something to access, why not just use what is tested and works already?

[kparker]

Thanks for your reply.

Here's the issue.....

I have the development on my machine. I always check the box in the template so that the procs are written to the access database. It works great.

My client has a copy of the vb.net application and the \"active\" copy of the database. He wants me to add a field or two to the database. I do it on my machine and it works great, but how do I get the \"updated procs\" loaded into my client's \"active\" copy of the database?

If could copy the \"create proc\" scripts created by the template, then execute them in an \"updater application\" that would then add the new fields to the database and update the procs. What would code look like to execute the \"create procs\"?