Which version of Access? I know that in 2003 and previous, there was a specific issue with dynamic sql.
The issue was that for if you had, for example, an import routine that used a query to import data, say, one date at a time, and you dynamically updated the sql for each date (or whatever parameter), such as one would in a non-parameter or a pass-thru, then each text of that sql would be invisibly saved to the .mdb.
So if you were doing an iteration for 365 days of data, and the sql was an insert for a table with 50 fields, that sql would be multiplied 365 times. This happened to me for an access front-end I used to move data from a db which had in the hundreds of millions of rows, and the sql was iterated on an indexed time field, 1 iteration for every minute (each minute had anywhere from 100 to 1000 rows) for a year. No data was being saved even temporarily to the access db--it was only acting as a middleman between two sql databases. The db would swell until it errored with an oversize limit before the process was done--a compact repair brought it back to minimal size.
--Jim
