By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 1,070 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

Suspend all the activities in Access till the job on SQL Server is over.

P: n/a
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 ?

Thanks,
Anand

Dec 26 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
So what is the "job" on SQL Server and how do you know when it's over?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200612/1

Dec 26 '06 #2

P: n/a
On 26 Dec 2006 02:36:27 -0800, an*************@hsbc.co.in wrote:

A "Job" is a very specific object in SQL Server. See Books Online. Is
that what you're referring to?
Otherwise we may need to see some code.

-Tom.

>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 ?

Thanks,
Anand
Dec 26 '06 #3

P: n/a

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

Dec 26 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.