Access FE file size keeps growing when data added to Linked SharePoint BE

[leishtheman]

Hi, my FE keeps ballooning in (file) size when data is added to my BE, but the BE is on SharePoint lists and is linked to my FE.

Any ideas why this is happening and how to stop it? Only thing I could find on other threads was to try using the 'recordset.close' method after using recordsets - I tried this but it made no difference...

Thanks
Andy

 

[JonXL]

Any possibility of narrowing down which operations cause the increase in file size? Maybe ask users what they're doing and then go in yourself and do those things one by one (closing after each time) and seeing which is to blame.

Alternatively, you may just decide not to worry about it since your users get brand new and separate FEs every time they access your app and so the file size increase might only be an issue if it's getting up in the gigabyte range after only a short bit of use (and so risks being unusable within a regular work session).

 

[leishtheman]

Hi thanks for the quick reply, yes it appears to be me who's causing it when I run append queries to add more data to the main SharePoint list. About 10 of us use the database and we all have separate FEs, but it's becoming an issue because whenever I need to e.g. make some small modification to correct a newly discovered bug, I can no longer issue the new versions via email and have to therefore mess around uploading them to SharePoint and getting everyone to download a new copy etc. With my broadband not being the best it's starting to take ages.

If the FE and BE were all part of the same file I could understand it, but as the BE tables sit on SharePoint it doesn't make sense to me why the FE keeps growing..

Andy