Recent content by ekrocker

Its the 2gb database size that's causing issues. The data is a directory of providers - listed in about 14 Excel files - each have the same columns. As I started importing each Excel spreadsheet into Access - into one table, the file size grew rapidly. I'd be set with just one table. I even...

So, I know how crazy this is going to sound but of course - higher ups want it and don't want to spent any money and basically won't take no for an answer. I have 4 tables across 4 Access databases 5+ million records total. I have a 5th Access database where I am linking in those tables and I...