My MDB file is 200MB after compacting. Is there anyway to compact the file further other than moving old records somwwhere else?
My MDB file is 200MB after compacting. Is there anyway to compact the file further other than moving old records somwwhere else?
Is your database split between front end and back end?
If so, you can further split your back end into seperate ones and link each one accordingly. A thought on this subject is to split it between tables that are changed regular and table that are primarily used as look up tables.
David
ON the import form, the following code had syntax problem:
Call Forms!ReconForm!SetRecon
(SetReocn is a sub procedure in the ReconForm!, Can I use the run function?)
You just need to code
Call SetRecon if the form is open and is the active form.