I am faced with the 2 GB/database limit. To circumvent, I want to create 2 databases on the back-end to store the same data and link the tables on the front-end. Once linked, I want to be able to use queries to edit/manipulate data in both data bases. However, I tested this process and it appears that I can certainly view the data in both, but I cannot edit/manipulate via queries using linked tables from both databases. Although, I can edit/manipulate with queries that point to each database, separately.
What can I do to be able to query AND edit linked databases in the same query? Or, is this a limitation in Access?