Access 97 database

Question

I have A .mdb file in my environment that was built on access 97. when I try to run either of my macros, it gives me error "3036", which means the database is full. I can't compact as <g class="gr_ gr_14 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="14" id="14">i</g> get an error for no read permission. kindly suggest how to reduce the database and any suggestion on where I can get access 97 - 2003 downloaded so that I can delete some of the data. 

the suggestions I have so far is to convert to a newer version which I cannot do because the .mdb was built on a 97 which I do not have access to anymore. 

thanks

Answer 1

Hello tyovince,

The support for access 97 is stopped and I could not reproduce your issue since i have no access 97 for testing.

According to your description, could you try to assign your account read permission to compact the database file?

Best Regards,

Terry

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

Backup.  Don't do anything until you make a backup copy of everything.

What about creating a new mdb file, exporting some tables and then compacting each mdb separately?

What is the file size of the mdb file?

Is your database properly split (front-end, back-end)?

 

So the database was created with Access 97, but you say you don't it anymore, so what version of Access are you currently running?  Why was the database not upgraded to that version?

Do you have any backup versions of the database that you can simply restore?

---

Daniel Pineault, 2010-2017 Microsoft MVP
Professional Support: http://www.cardaconsultants.com
MS Access Tips and Code Samples: http://www.devhut.net