Recent content by pghquest

btw, when I hit the debug button, this line is whats in yellow Set rst = CurrentDb.OpenRecordset(sql)

ok I'm stuck. I have a SQL query that when I run through SQL, it works fine. It queries 2 separate database tables and finds ones in 1 database, not in the other, and then counts them. The code below, I copied from another part of my vba which works, and then modifies, but that only looks at...

I was looking at doing just that cjman, but I cant really find a website online to tell me how. I can write the queries into SQL, but I cant figure out how to save them, so I can call them from Access. btw, the other 32 gigs of ram arrived last night, so I'm up to 104. Performance boost...

If I double click the query itself in access, it might take a second to run. It runs just fine, its a SQL pass thru query.. It doesnt lock up all the time, just on occasion. I've got a series of these that run, it might run the first one, then lock up on the second one, or the third.. Here...

Well I'm back.. problem continues to bug me now that the database has gotten bigger. Hoping people will have ideas.. If I run the queries all by themself, they run just fine, in both access, and SQL, only when I tell the VBA code to run the queries do they lock up.. VBA code looks like...

Sorry it took a few days to get back to the thread, wanted to update it. I ended up getting someone to create a loop for me, to update 100 items at a time, and then display on the screen how many items were left to update. That way i can tell if it locked up, or just taking some time to do the...

Re: Access locks up on pass tru queries Well I need the triggers to run on all of the rows updated.. I did get close, if I break it up into small queries it runs pretty quick, so I'm thinking of creating a loop but when I do Dim total as Integer SQL = ("SELECT COUNT(*) as total FROM...

Re: Access locks up on pass tru queries One more question, (Bear with me, just want to try to summarize everything at once).. I'm using a macro to run the command in VB to run the query, is it possible to run a query that looks and sees how many changes need made and then run loops of 100...

here is the situation, I'll try to be as detailed as possible I have two tables in SQL 2008 R2, on windows 64 bit, with 40 gigs of ram, and 4x quad core processors. Table 1, has about 60,000 recods in it Table 2 has about 25,000,000 record Both of these tables are in SQL, (database size...