1. On the SQL Server, create a Stored Procedure that runs the job.
2. In Access, create a Pass-Thru Query that executes the Stored
Procedure. Make sure to set the Time Out property on this query to 0
(No time out).
That's it!
On 26 Dec 2006 02:36:27 -0800,
an*************@hsbc.co.in wrote:
>I access certain tables of SQL Server on Access front-end. I want to
suspend all the activities on front - end till the job on SQL Server is
over.
Any ideas how I about it ?
--
Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing