Acess size 2bg

[CLEMENCY]

I have a access db zkteco.mdb that reached its max size but nothing changes on its size even i purge data.


But when a open and save as zkteco copy.mdb its size decreases. Whats wrong with this. Help!!



MICROSOFT OLE DB JET PROVIDER

[CJ_London]

to reduce size you compact and repair - however for mdb's once the max size is reached the compact and repair does not work and you have to create a new copy

[CLEMENCY]

thank you.

[HiTechCoach]

Is the application split into a front end and back end?


For an MDB, I like to use this tool to compact when the size gets large:
Jet compact utility

The Jet compact utility, JETCOMP.exe, is a stand-alone utility that compacts databases created with Microsoft Jet database engine 3.x and 4.x. This utility may be run in conjunction with Microsoft Jet database engine 3.x and 4.x for recovering corrup