I have a general question regarding linked databases. Since I have not used this feature before, I would like to know:
- If each DB has assize limit of 2 GB, and if each approaches 2GB, will the linked DB’s (via linked corresponding tables) still function correctly, without crashing?
- Assuming that the answer is yes to the first question, is there a limit to how many such DB’s can be linked, and is each subsequent destination Table renamed in sequence (i.e. Table1 becomes Table11, Table12, Table 13, etc.)?
The reason for my question is due to the fact that since we import images into the Tables (I know that we should keep images in tables outside of Access) our DB tends to reach the 2 GB limit over time.