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.
thanks
Art Of Living Is Art Of Giving
