Tablespace isn't used in the database when you link a table. (Only a small amount to store the link information)
You'll have to compact & repair the database however after moving a table to another database, else the used tablespace won't be freed up by Access !
Nic;o)
Thank you for the prompt reply. That would have been my expectation. What I did was insert data records via VBA code (large amounts) into linked tables in a fully compacted database 'primary.' As I said in my original post, these tables are resident in another Access 97 Db. What happens is that there is no difference in the resulting size of the 'primary' database after the insert as compared to inserting the same data into the tables as if they are resident in the 'primary' database.' As a further test, I removed the linked tables entirely from the 'primary' Db, compacted again, while leaving the tables still in a separate Db. I performed the same insert to these tables directly from one Db to another. In this instance, the 'primary' database had marginal size growth and the Db holding the data tables grew to about 1/2 the size of the 'primary' Db under the earlier tests. Since I am starting to exceed the 1 GB Db limit, I am needing an alternate solution. It looks like holding the tables in a separate Db and inserting directly is the way to go.
Thanks again for your response.
Marmadmax
2
