More Info

J

Josh

Basically Iam trying to create a SQL script, that copies all of the tables
(already done), stored procedures (not done) and data (done) from a SQL
Server Database into an Access Database.
 
L

Larry Linson

Josh said:
Basically Iam trying to create a SQL script, that copies all of the tables
(already done), stored procedures (not done) and data (done) from a SQL
Server Database into an Access Database.
Click to expand...

Perhaps the reason you can't copy Stored Procedures into an Access (Jet
database engine) database is that there is no such thing in a Jet
database -- stored procedures are not supported.

A close approximation, but not exactly identical, would be saved Queries.
Jet SQL has some modestly significant differences, too.

Larry Linson
Microsoft Access MVP
 
Top