Thanks hollystyles, in the meantime I was going to create an MDE and put it on a Network Drive however what I want to do was the following. Our Network can be incredible slow at times because so many others are working from it. So i wanted them to go into the Network and click and executable that zips everything into a specified folder.
I hope I am not confusing you but I thought I had seen this done before...
You can't do that with the normal access package. You have to have a developers package that allows you to distribute the code.
Err..Yeah.. I'd already explained that.
What Dubz want's now is a way to zip the files for a user. I don't quite get the reasoning behind that without more information, why can't you just zip the mde on the server and copy it into the share? you could do it with a batch file I imagine, is it a windows server? or a SAMBA share or what?