How do I read data from zipped Access file

[gtbugbee]

I have a problem reading data from Microsoft Access file that is zipped.

I have a .NET application that searches the network for Access files. I copied "getallfiles" routine from internet (works well). I put ".mdb" as part of search parameter, so I only get Access files. The resulting file pathnames are in a list for user to choose. The application will then use OleDbDataAdapter to read partial data from the chosen file. This works OK.

The problem is that some Access files have been zipped. So I added ".zip" to search. The program errors as unrecognized database format when trying to read zip file. How do get .NET to read data from a zipped file.

 

[jebenson]

VB .NET does not have any zip functionality, so you will have to use a 3rd party component to unzip the Access files. Check this link for a discussion of this topic.

http://www.codeguru.com/forum/showthread.php?t=443029

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

Arrrr, mateys! Ye needs ta be preparin' yerselves fer Talk Like a Pirate Day!