Emulate SQLServer Stored procedures in Access

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tim Smith (tim_at_hotmail.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 16:28:35 +0300

Is it possible to emulate SQLServer Stored procedures in Access?

I've got a VB6 application that uses as Access 2000 database with ADO
Very often this application has to execute a series of SQL statements
against the DB.
It would be a huge saving (in development and testing time) if there was a
way to
create something like an SQL Server Stored procedure and execute all sql
statements in a batch

Relevant Pages

  • Re: A peculiar problem
    ... > and then to execute them. ... Text manipulation in SQL Server is very hard, ... > 1.Create a batch file with isql utility using an input file and putting ... Export the generated file(with the modified stored procedures) using ...
    (microsoft.public.sqlserver.programming)
  • Re: Poor performance when executing stored procedure
    ... > Generally I would write stored procedures to do only one job. ... If SQL Server ... > which is even worse those sps can execute each other. ... > then executed spOrders which is executed in spCustomers and then got stuck ...
    (microsoft.public.sqlserver.programming)
  • Re: PHP/Oracle - Pulling data into array
    ... MySQL has the flaw that you have to stuff values into SQL statements, ... DATA with SQL. ... Depending on what interface and database you're using. ... time it comes across a new statement, it works out the best way to execute it. ...
    (comp.lang.php)
  • Re: PHP/Oracle - Pulling data into array
    ... MySQL has the flaw that you have to stuff values into SQL statements, ... DATA with SQL. ... Depending on what interface and database you're using. ... time it comes across a new statement, it works out the best way to execute it. ...
    (comp.lang.php)
  • Re: Problem with program hanging - SQLServer issue?
    ... > queries the program makes to an SQL Server database. ... > Public WithEvents SQLServerCN As ADODB.Connection ... > I execute some stored procedures like so: ... > And a couple of SQL statements like so: ...
    (microsoft.public.vb.database.ado)