Big files

[jcsuarez]

I´m using ACCES 2003 and ACCESS 2010 in different PCs, with Replicated Tables located in a single file (in order to share them between different files of a single Application). I realize that the file with the Tables grow very much, as far as 800 Mb, when I make the Tables replicable. It´s there any way to avoid this stretching?

 

[Ranman256]

Youre fine until 1.8 gig.
Id try compressing every now and then. does this reduce it significantly?

 

[Trevor G]

2 options that I see. First Compact the database. Second consider splitting the database so the tables are in one database and the front end is in another. Does the database reside on a Network drive?