Hi All,
Trying to get around the 2GB limit in Access (using 2010 version). I have split the database up into 4 separate databases each with a few tables. I then have another database that does not own any tables, but instead links to all the other tables contained in the 4 separate databases. My VBA code then only interacts with this "mother" database. Again this "mother" database does not own any tables, only links to them so my code can just connect to the "mother" database and not have to worry about connecting to the 4 separate databases that hold the actual tables.
I've noticed my "mother" database file size is growing with the more tables I link to. Is this "mother" database also subject to the 2GB rule? By linking to more and more tables in other database files, and those database files growing, will my "mother" database hit 2GB and so this is not effective? Instead of using a "mother" linking database, should I just write my code to connect to the 4 individual separate databases that actually hold the tables?
Thanks!
Jeff