Re: Access to zipped Microsoft Access database

mark wrote:
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


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.
.

Relevant Pages

  • Re: QRe: Legacy Access 2 VB 4 app, Word 11 merge on XP Pro SP2 client
    ... selecting "blank database" or some such. ... possible to set a simple password on a whole mdb file, ... case, make sure you have a backup of the .mdw file, then launch Access ... >I could not get the app to accept the changes to Notepad within the ...
    (microsoft.public.access.conversion)
  • Re: Basic security questions
    ... Your ASP page would "connect" to the file on the Unix box via ADO or ADO.NET ... Password protected databases are different from database protected by ULS ... ULS protected databases require the use of the .mdw workgroup file ... >> If you double-click an mdb file, the sequence of actions is as follows. ...
    (microsoft.public.access.security)
  • Re: Creating a new Access database file (.mdb) in .NET/C#
    ... create an empty shell MDB file and you can then run ... copy the MDB file to a folder and run the DDL against it ... I'm making changes to a small, portable, single-user database ... Frank McKenney, McKenney Associates ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help connecting to Access DB from web service
    ... I would love to move the database to SQL Express but that is not an option ... Given that I can not move the data to a better database, ... application that will also open and access the mdb file, if so, I'm ... appliation runs under the asp.net worker process (under the worker proces ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Editing a Front-End Database
    ... The front-end database seems to be called .mdb not .mde. ... BUT, when you convert a .mdb file to a .mde file, you ... design changes while anyone else is accessing the database, ...
    (comp.databases.ms-access)