Re: How to protect data within MS Access?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

we are talking about .mdb with two tables, the first one is approx
250.000 to max 300.000 rows with 3 columns and second one is approx
100 rows.

We are not expecting from user to update existing record, ony reading,
searching (standard search based on column result (WHERE) and
incremental search)

On Thu, 26 Jul 2007 09:41:16 +0100, "Mark Rae [MVP]"
<mark@xxxxxxxxxxxxxxxxx> wrote:

"Mike" <ablyplus@xxxxxxxxx> wrote in message
news:fpfga3tq8m9nk6hpqp4rmoa4h5snarna56@xxxxxxxxxx

If protect MS Access with password it doesn't mean to much. On
internet, we can find plenty tools for opening forgotten passwords
etc.

I'm guessing that you don't actually mean Microsoft Access, but are talking
about a Jet (.mdb) database...

What I should do, is there some example of encryption data within db
or what.

There is no way to secure a Jet database, as there are any number of tools
available which will remove any security, including database password,
workgroup and encryption. These will make the database harder to open for
average users, but a professional will get in in seconds...

How I can do that on different way, I can buy some component, or I can
use some another db, but I am not sure what exactly. I have win
application and I have to provide automatic setup...

How much data are we talking about?

Will the user be expected to update existing records / insert new
records...?
.

Relevant Pages

  • Re: Can inner join replace multiple loop selects?
    ... if you anticipate creating business database applications with the ... if you are using the Jet database (.mdb file ... format), DAO is the "native language" of Jet. ...
    (comp.databases.ms-access)
  • Re: Access + Asp + multiuser + table lock
    ... >> MDB front end with shared MDB back end. ... >> Jet database, just one single user. ... Part of your problem may very well be the single user locking ...
    (microsoft.public.inetserver.asp.db)
  • (no subject)
    ... - LDB locking which a persistent recordset connection fixes ... New format of Access 2000 MDB ... Place backend MDB on the root of the network share rather than several folders down ... Subdatasheets are a new feature in Access 2000 Therefore, you are more likely to notice this behaviour after you convert a database from an earlier version. ...
    (comp.databases.ms-access)
  • Re: temp db
    ... If the database is not in use, you can create a copy just by copying the MDB ... The purpose is to create a temp db for all the ... ' This subroutine illustrates how to use a temporary MDB in your app. ...
    (microsoft.public.access.formscoding)
  • RE: Access to Access Automatic Updates
    ... Then navigate to the database from the File Open dialog and open it. ... You will need to do it for mdb that has tables you need ... MS Office Master 2000 ed. ... you will need to create a form that opens on ...
    (microsoft.public.access.externaldata)