George Georgov (2/9/2006)

Well done. This is realy good. It work on single sql server. But on the cluster it is not workable.

If i apply this on the sql cluster, then...

The stored procedure executed directly using ADO from the client takes 16 seconds to run....so I was investigating hwo to run the procedure in the background (on the server) without...

/bump

If anyone can help

The stored procedure I am executing from the trigger is found here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=366303

I beleive now after doing a simple stored procedure it has something to do with not liking...

I have gone through my stored procedure and made it as efficient as I possibly can, the time it takes to run is purely because of the amount of records...

Ok so ive messed around with my code a little

Dim strBatch As String

    Set cnn = New ADODB.Connection

    cnn.Open "Driver={SQL Server};Server=GMSQL1;Database=GLOAD;Trusted_Connection=Yes;"

    Set cmd = New ADODB.Command

    strBatch =...

Anyone?

/Bump

I am running the code from a pass thru query with the parameter built in vba from the combo box value the user chooses.

How do I run it asynchronously?

Btw there is...

very very very very late reply, but this has very much helped me in my further endevaours in stored procedure running.

And you simplistic way of explaining this made it all...

Yeah he can quite easily jsut upszie the backend then link the tables form the SQl back to the access front end...but he might as well at least look at...

I cant see a reason why you wouldnt want to use the Project rather than the normal access DB.

When it comes to using a project you get the benefit of...

I would merge the front end and back end then do an upsize.

Detail :

DB-Backend is Access 2003

DB-Frontend is Access 2003

Why not import all the tables into DB-FRontend from DB-Backend then...

There are roughly 90 fields in this one table and just about all of them are requried to be viewed by the form. There are 2700 + records totalling around...

Just to conclude this..in case anyone else has the problem i did the following.

I downloaded the trial version of SQL and installed it on my local computer. (as recommended above...

ok sorry about that, stupid one probably. But it turns out after rebooting the computer they can then see the DB in the list to add as default in the...