Then run the job on the server, NOT from your local PC.
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?
Pat, that DOES assume the OP has Access available on the server.
@Oriel Tzvi Shaer - I will have to disagree with you. In order for you to use an Access BackEnd file properly, you MUST have "MODIFY" level privileges on the BE file AND on its folder. Which means you can, if no one is currently using the DB, perform the C&R locally and then just overwrite the BE. If you are the "official" maintainer of the BE file, that IS a valid maintenance activity. When I was a contractor for the U.S. Navy, which had ALL SORTS of regulations about what I could and couldn't do, that kind of replacement activity was still allowed.
I have all access and previliges I need, but I need to do C&R specificly after I connect the linked tables of DB to external SQL Server.
Actually, maybe I should have made it clear earlier: I work with SQL Server databases.
Anyway, in order to connect to SQL DB, the accdb file need to be in Server - there I have the appropriate ODBC connections I need for connecting the linked tables.
What I could do is: after connecting the linked tables, copy the file back to local computer and then C&R - but that would really take much longer - if my whole concern is the time it takes.
In addition, the C&R happens in memory on your local computer so everything in the db must make at least one round trip between the server and your PC which dramatically increases the amount of time it takes. Take a large db that you don't care about. Compact it while it is sitting on the server and time it. Then compact the original version on your local PC.
I wanted to ask about this:
What difference does it make for Access if I am physically on Server or from afar?
How can it tell the difference?
What sense does it make to do the job locally - why does Access bother to do the job on my local computer?
Thank-you all for the patience!
Such environment really allows learning!