Access Stored Procedures

[Josh]

Hi Guys,

I have a SQL Server database and I need to dynamically make a copy of it to
an Access database. I have managed to get all of the tables into the access
database and I can get the stored procedures out of the SQL Server database
but I can figure out how to get them into the Access Database using SQL.

I have just read in the Access help that the JET Database engine does not
support the statement CREATE PROCEDURE. Is it possible to add a query into
an Access database using SQL code??

Thanks for you help,

Josh

 

[Graham R Seach]

Josh,

Before we start answering your question, what is it you're actually trying
to do, and why?

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Van T. Dinh]

If you use MDB file in A2K0 or later, check Access Help
(JET SQL reference section) on the "CREATE PROCEDURE ..."
syntax. Note that it is most likely you need
to "translate" the SQL String from the SP of the SQLServer
to JET SQL syntax.

You also need to use ADO to run your "CREATE
PROCEDURE ..." statement as the Access Query Design (SQL
View) does NOT support the CREATE PROCEDURE syntax.

There is also CREATE VIEW ... syntax. Check Access Help.

HTH
Van T. Dinh
MVP (Access)