I have an Access database linked to Sharepoint. This works very well but the file size of the database file .accdb is large: 2GB large!

The main tables have only around 750 entries, mainly containing contact information and not much else. There are related tables to this and a little code but nothing extensive.

I originally thought the large file size was because of a long text field that I use for notes. I have since stored these in rtf files in each record’s library that loads when a form is loaded and have deleted the field from the tables and relinked. Unfortunately, the size of the file is still 2GB and I do not know why even after compacting and repairing. I expected that the file size would be drastically reduced.

I have kept the original “offending” tables as copies in Sharepoint in case they are needed but they are not linked.

Is there any way of checking what could be causing the file to be so big?