Re: VBA - Testing Links to tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Mary Chipman (mchip_at_online.microsoft.com)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 10:20:33 -0400

You can execute a stored procedure by creating a pass-through query in
VBA code by creating a DAO QueryDef object and setting its connection
and SQL properties. You can prompt the user for security credentials
and test the connection prior to executing this code, and cache the
connection string in a global variable for reuse in the application.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Wed, 16 Jun 2004 09:27:43 -0400, "rob" <rwc1960@bellsouth.net>
wrote:

>Using an Access 2000 database and linked SQL tables...
>
>Before running a procedure which will replace data in the local Access db
>with data from SQL server, I would like to test that a "good" connection
>exists betweeen each SQL server table and the Access database. (I do not
>want to replace the data if I cannot get a "complete" set over.)
>
>Is there a preferred way to do this ? Any code examples or books that
>cover the topic ?
>
>Thanks !
>
>

Relevant Pages

  • Scheduled DTS package doesnt run
    ... I created a DTS package wich runs a standard Stored Procedure in the master ... I call the stored procedure by an Execute SQL Task object with all necesarry ... When I log on as administrator on the server and run the package manually it ... Error string: SQL Web Assistant: Could not execute the SQL statement. ...
    (microsoft.public.sqlserver.dts)
  • DBI stateHandler bind_param errors
    ... I have a real problem with calling a stored procedure on MS SQL Server ... def connect ... puts "Connection Successful!!!" ...
    (comp.lang.ruby)
  • SQL Server 2000 (Application) Role accessed through ADO.NET
    ... users from connecting to SQL Server through other MSOffice ... The database role claims to answer my ... I establish the connection to the database ... I execute sp_setapprole stored procedure (providing the ...
    (microsoft.public.sqlserver.security)
  • Re: Issue with retrieving large data over web using Stored Procedu
    ... It appears that it was hitting the stored procedure, ... Is there any tool in the SQL Profiler that analyze each Trace? ... The maximum amount of time for a script to execute was exceeded. ... do it at ASP. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Considerations migrating from Access 97 mdb to Access 2003 (or up)?
    ... of a local table to set up the connection ... so I don't know why you can't just execute the SQL ... nor even with a special workspace. ...
    (comp.databases.ms-access)