Recent content by mikeva

Well, your database is 1/2 Mb in size. Mine is 1/2 Gb. My tables only have to be loaded in memory 3 times before I exceed the 2 Gb limit. I appreciate the time you've taken to help out. Thank you!

Thanks so much. However, I find this query is causing Access to crash. I get a "cannot open database" error when doing this. When performing this query, my db grows from 1/2 gb to the Access limit of 2gb and then gives me the aforementioned error message. While I think I can get my hands on...

Hi there! I've got a complex query and am not sure how to accomplish the task. Here's the basic rundown. I have three tables, Old, New, and MergedTableResults. The tables all have the same data structure, and the fields are A, B, C, D, E, F , G, H, and I. Fields G, H, and I do not...