Search results

At the end of the day, in the way we link the tables to specific SQL DB, it causes the size of the Access file to increase significantly, and C&R helps return it to it's original size. Though it really doesn't matter - why, I am trying to focus on answering the original question, whether it...

Returning to original answer to original question: In my case (though FE yet...) it was simply a case of insufficient memory on the computer. (taken out the "server" business - though it was fascinating learning new facts and experience from you all) Clearing some memory solved the problem. I...

If I understand you correctly, that's also quite impossible for me to take a trip to from Israel to Germany every time I would need to do the job. If I didn't understand you correctly, then how do I get around doing it on the server itself from where I sit physically? I have all access and...

Indeed we do. All is done on copy only

Thank-you both - I learned. In my case, I don't have the option to do it locally. The good thing is we have good network connection to it. I tested C & R locally and on server (DB of appr. 200MB), and surely enough it took twice as long (locally ~5 sec., server ~10 sec.), but, as I said, it is...

Could you please explain more: What's wrong in doing so?

In my case it was simply a case of insufficient memory in the server I was running the Compact and Repair. Clearing some memory solved the problem.

Shalom, My name is Oriel-Tzvi Shaer. I'm from Israel. Joined this forum in order to be able to engage in discussions if I have something to add to them It's nice this suggestion to introduce oneself, in this era of nearly talking to robots - good to remember there human beings out there. Good...