I cannot find compact and repair. I have used encode/decode but that is a lot less convenient than the old compact and repair. I ran into a situation today where it says the owner of the db has to encode / decode and it won't let me. This is a database I created from scratch so why I'm getting that error would be an additional question.
I frequently copy databases for each month where I copy say October, rename it November, delete October's data, and import November's data. If I do this without encoding, the database will simply double in size even though I've deleted Oct data. I used to just compact in older versions of Access but this option no longer appears to be available.
Please help.
Thanks
I frequently copy databases for each month where I copy say October, rename it November, delete October's data, and import November's data. If I do this without encoding, the database will simply double in size even though I've deleted Oct data. I used to just compact in older versions of Access but this option no longer appears to be available.
Please help.
Thanks
