Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
eats memory and generates maximum size error
Problem resolved - used a 'false' query by: Set qry = CurrentDb.CreateQueryDef("") With qry .SQL = " ... This is treated as a JET operation and not a DAO, therefore not adding to the size of the db...- ballizz
- Post #4
- Forum: Microsoft: Access Modules (VBA Coding)
-
eats memory and generates maximum size error
Sorry... was in a hurry, didn't notice... Basically, making a log table for errors found on a main table, verifying some of the fields on the main table through repeated SQL use of a temp query, and populating the error table with an ID, field error found in, data in field, and short description...- ballizz
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
eats memory and generates maximum size error
The code below keeps increasing the size of the database until max size (1 G) is reached, at which time it errors out. Can anyone point out to me which area(s) are causing this? The "Check_" table, after running 2090 records (the highest count I've gotten to) only has 14 records at...- ballizz
- Thread
- Replies: 3
- Forum: Microsoft: Access Modules (VBA Coding)
