Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Lightbulb Unanswered: Converting Stored Procedures back to MS Access Queries

    I know its a weird request, but we have created an application with sql server but our client wants a version which can be put onto disk.

    We decided to create the stored procedures into queries, would this be the best idea and if so does anyone know if there is a freeware software that can do this or will I have to painstakingly re-create the queries?

    Any advice would be greatly appreciated.

    Many thanks

  2. #2
    Join Date
    Jun 2003
    Provided Answers: 1
    You can't convert any but the simplest sprocs into Access queries. Sprocs can be mult-step, while Access queries are simple statements like SQL Views. You would have to write VB code to simulate the sprocs, and there is no utility I know of that will do this for you.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts