Hello
I have an access dB that stores meeting minutes as attached documents. This has caused the databas (I think this is why at least) to reach the 2gb limit.
Ive moves 50% of the records to a backup dB to hopefully reduce the size. I’ve then tried decompiling and compacting however it makes zero difference, I think because a message comes up stating ‘property not found’ During the process. This error appears to relate to a specific table, and it’s an old table which is no longer used, so I tried simply deleting the table with no luck - I just receive the property not found error. I cannot open the table in anyway either.
Is there anyway I can either resolve this error to enable compacting, or does anyone else have any other ideas at all please?
The dB is already split between FE/BE too.
Thanks in advance!
I have an access dB that stores meeting minutes as attached documents. This has caused the databas (I think this is why at least) to reach the 2gb limit.
Ive moves 50% of the records to a backup dB to hopefully reduce the size. I’ve then tried decompiling and compacting however it makes zero difference, I think because a message comes up stating ‘property not found’ During the process. This error appears to relate to a specific table, and it’s an old table which is no longer used, so I tried simply deleting the table with no luck - I just receive the property not found error. I cannot open the table in anyway either.
Is there anyway I can either resolve this error to enable compacting, or does anyone else have any other ideas at all please?
The dB is already split between FE/BE too.
Thanks in advance!