Re: How to protect data within MS access?


"Mike" <ablyplus@xxxxxxxxx> wrote in message
news:2ejha31hflmlm7kaukobhb6m77n2gfrgg6@xxxxxxxxxx
It is simple, I have a small client application, windows c# .NET,
framework 2.0...

Within mdb are two tables, the first one is approx 300.000 rows, and
second one is approx 100 rows. User reads (no update) and search data.
Search is normal with WHERE clause based on column value and
incremental.

<snipped>

Then the answer is still the same. It is practically impossible to protect a
file that anyone has physcial access to. If you have control of the box then
you can prevent physical access administratively through the operating
system. Otherwise, you either accept a certain amount of insecurity, or go
to something else. (SQL Express might provide some additional protection.
<?>)

But you just mentioned you are using dotNet. Then this is not the newsgroup
for you. This group is for questions concerning classic ADO only. I would
post your question in an MSAccess developer's group for suggestions on
security. And in dotNet group for questions on encryption.

hth
-ralph




.

Relevant Pages

  • Re: How to protect data within MS Access?
    ... to max 300.000 rows with 3 columns and second one is approx ... about a Jet (.mdb) database... ... There is no way to secure a Jet database, as there are any number of tools ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: How to protect data within MS access?
    ... second one is approx 100 rows. ... Is there some solution of problem and how I can protect my data??? ... There are two levels of protection for an MSAccess database. ... might be good enough in a controlled situation (where you can control ...
    (microsoft.public.data.ado)
  • MCBs in consumer unit.
    ... Our holiday home has a Crabtree consumer unit with approx 10 MCB's and ... an RCD fitted in the middle of the switch bank, I assume to protect the ...
    (alt.home.repair)
  • Re: What is the fastest way to verify a record exists?
    ... > I have a data table (linked to the Front end mdb) where each record has a ... > currently has approx 300k records. ... > From the Front End what is the fastest way to verify a particular job ... Then see if it is empty. ...
    (microsoft.public.access.formscoding)
  • Access behaviour when near 2GB Limitation?
    ... limit while it has a lot of unused space within the mdb? ... the the mdb size to approx. ... the file size reduces to approx 500MB. ... the process execution and tends not to reuse the unused ...
    (microsoft.public.access.tablesdbdesign)