Need to delete data from MSysAccessObjects

[dwalker]

I have a very simple database consisting of a table with 1 field - [image_path] - which stores the DOS path of a list of JPEG images. There is also a form which contains 30 image controls. On loading the form I have code which sets the linked image path in each control to the paths listed in the table - the form then opens displaying the images according to the paths stored in the table.

Everything works fine. My problem concerns the system table MSysAccessObjects which has quickly grown to over 100MB. I assume it's caching the image file data - remembering that no images are embedded, all are linked.

What I need to know is if there is any way I can delete this data from the MSysAccessObjects table as the total database size is ridiculous considering it consists of a form and a 30 record table.

If there's no safe way to edit this table does anyone know how else to prevent it getting so big?

Compacting the database has no effect.

 

[KenReay]

Hi

Tinker with the System table at your peril. How do you know THAT table is 100Mb? Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[dwalker]

The table I created is only 30 records in length, so is therefore tiny. The only other tables in the database are the System tables. Each of these is 30 records or less, except MSysAccessObjects which has over 25,000 records.

 

[tman138]

Try building a new database and importing all of your database objects and code. Make sure that your code references are the same and be sure to compile and save your code before closing the database. Also setting your general options 'Compact on close' to true may help eliminate future occurances.