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
Novice
Windows 7 32bit 
Access 2010 32bit
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
VIP
Windows 10 Access 2010 32bit
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
Novice
Windows 7 32bit Access 2010 32bit
thank you.
MS MVP - Access Expert
Windows 10 Access 2013 32bit
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
Boyd Trimmell aka Hitechcoach
Database Architect and Problem Solver
Microsoft MVP - Access Expert
25+ years specializing in Accounting, Inventory, and CRM systems
"If technology doesn't work for people, then it doesn't work."
Access size limit , Any options to prevent reaching its file size limits?
Have a form of a specific size display in that size rather than the whole work area
Help Acess to DB
Posting Permissions
Reply With Quote