I have a working system which gets data from remote databases chosen from a selection form in a 'switchboard' database. However, because of network space problems (I've never known a network that doesn't have space problems!)the remote files are now being delivered as WinZip archives. Does anybody know how I can code my project to open the archives and extract the zipped mdb file to allow me to copy in or link to tables? Currently using Access 2002 on XP Pro.

Many, many thanks.

Alan T

I use Winzip with its 'Command Line' add-on. You can download it after registering WinZip.
This gives you access to WZUNZIP.EXE as a command line program. Read the documentation that comes ith it.

I use Shell('Unzip command line string') to use it within VBA.

Cheers Ray