More Info

  • Thread starter Thread starter Josh
  • Start date Start date
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What are the steps to fix damaged MDF files in SQL Server? 0
Call stored procedure in SSMS from Access 2016 doesn't work. 0
How to link a Access FE to SQL Server BE 10
Record-Locking remains open after closing 0
Best way to deploy Access read-only database that is linked to SQL tables 6
Access Front - Sql Back End 6
How to create a table from SQL Server query result 3
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1

Back
Top