Ms Access File Size Increase and corrupt it. RRS feed

  • Question

  • hello friends,

    i have 2 access file one file is around 200 mb file size, In this file i get some data from another file as temp data, this data store in a temp table and after work i delete this table. now the problem is after this ms access file size increase around 150 mb more and repeat this step 8 to 9 time the file size goes to 1800 mb and then it corrupt. around 8 to 10 user working on this file. Please tell me the solution how to decrese the size of file if i used compact option then i have to closed all user work which is not possible. Please tell me solution.



    Art Of Living Is Art Of Giving

    Thursday, May 28, 2020 11:51 AM