Access to zipped Microsoft Access database

Thread view:

mark - 05 Nov 2006 15:19 GMT

Hello,

I have no problems with connecting to ms access database, although now
I want to connect with a mdb file which is zipped. Is it possible to
unzip it only in memory (without saving to a hard-drive) and connect to
such database?
The reason is that I just don't want to publish mdb file which can be
easily accessed and modified by other and putting it in zip with
different file extensions can make that task little harder.

Regards, mark

Reply to this Message

Arne Vajhøj - 05 Nov 2006 18:14 GMT

> I have no problems with connecting to ms access database, although now
> I want to connect with a mdb file which is zipped. Is it possible to
[quoted text clipped - 3 lines]
> easily accessed and modified by other and putting it in zip with
> different file extensions can make that task little harder.

I don't think the Access ODBC driver will support it.

You could enable security on the MDB though.

Arne

Reply to this Message

C Student - 07 Nov 2006 06:26 GMT

> Hello,
>
[quoted text clipped - 7 lines]
>
> Regards, mark

Hiding files in a zip file offers you no protection what so ever. For
example on any unix based system using the file command will tell you
what type a file is regardless of file extension.

$ file filename.odt

filename.odt: Zip archive data, at least v2.0 to extract

As you can see 2 seconds work on a unix box will tell me what type of
file you are using. Unzip it and I have your database and can do what
ever with it.

Reply to this Message

webmaster.hxtt@gmail.com - 08 Nov 2006 13:33 GMT

> The reason is that I just don't want to publish mdb file which can be
> easily accessed and modified by other and putting it in zip with
> different file extensions can make that task little harder.

HXTT Commercial MS Access JDBC driver(http://www.hxtt.com/access.html)
supports to visit mdb file in jar or zip file with different extension
except for MDB. You can find How to Use Memory-only Table, Physical
Table, Url table, Compressed table in a SQL at
http://www.hxtt.com/access/advanced.html#mining .

Reply to this Message

Access to zipped Microsoft Access database

Free Magazines