You can't, but you can re-distribute an access run-time engine that means people can run the db withpout having to have Acces themselves.
To be allowed to do that you must be a licensed holder of Microsoft Office Developer edition.
http://www.developer.com/tech/article.php/721181
If all your users have Access, just put your .mdb in a shared folder on the server, users on the network can run it directly from there through a mapped network drive.
Ideally you should convert it to an .MDE (it's on the access menus someplace) this sort of seals it up a bit so noone can muck about with the tables and queries and stuff. (unless the're clever he he)
hollystyles
Veteran Poster
1,182 posts since Feb 2005
Reputation Points: 262
Solved Threads: 68
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?
hollystyles
Veteran Poster
1,182 posts since Feb 2005
Reputation Points: 262
Solved Threads: 68