Database Size

[Rick West]

We have a FE/BE application. The size is outliving Access's capabilities to keep up with the data (we are looking into SQL'ing it) but in the meantime, what if we split the BE side into 2 databases would this give us more room? Pro's/Con's of splitting the BE please.



Yes we compact/repair it every night.

[RuralGuy]

Each split will give you 2GB's of additional space with no down side.

[Rick West]

Thanks, that's what I thought but I wanted to check with you guys first.

Keep up the good work, all us users really appreciate your help even if we don't say it often enough.