Search results

What I was planning to do was have another master database run the database that does all the calculations (the secondary database). When this secondary database reaches a certain size (from the IF statement), it would jump to the end of the code in the secondary database, and the master...

The weird thing is, after further investigation, is that it actually works on my home PC (as opposed to my work PC). The only differences being that my home PC has a higher spec, and is not running a monster SQL query that connects to several linked oracle tables before the loop (which contains...

Hi all, I am having problems using the filelen function to determine the size of a database while the code is running. I have an Access database that is performing numerous calculations 1000’s of times with tables/temporary tables etc. The problem is that eventually Access exceeds it’s 2gb...