Re: How to protect data within MS access?


"Mike" <ablyplus@xxxxxxxxx> wrote in message
news:ek2ja31irpmnhu19k5ir7o6h087pmhu2vg@xxxxxxxxxx
Thanks Stephen , I understand. My application is client application
and plan is to be a cheap. I do not know how to use Oracle or SQL
server in this way...

Mike


You can distribute a SQL Server Express database as a file. Just as you
would a MDB.
You can also install SQL Server Express along with your application just
like you would have done in the past with MDAC or Jet packages. The install
is swift and quiet.

But again, even though a SQL Server Express database does provide a certain
amount of security over a MDB, (simply because of its less well-known format
and built-in optional encryption), anytime you allow physical access to a
file - somebody, somewhere can 'break in'. You can reduce the target's
surface but you can never eliminate the target entirely. <g>

-ralph


.

Relevant Pages

  • RE: database options with SBS 2003 R2
    ... It was doable for the customer to design their own access database in a peer ... If you don't want to deal with a version of SQL Server for the data, ... end MDB files. ...
    (microsoft.public.windows.server.sbs)
  • RE: Access project vs. Access db
    ... Code and techniques that work fine in an MDB don't always work ... route with an MDB database file instead. ... > the SQL docs, but in the meantime, what is the correct syntax for Boolean ... Jet won't warn you of this logic error, but SQL Server does. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access 2002 Upsizing Wizard does not copy forms
    ... Upsizing *.mdb to SQL Server, using Upsizing Wizard, ONLY transfer data from ... Jet database to a SQL Server database (either new or existing, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: database options with SBS 2003 R2
    ... MSDE is the lightweight, free version of SQL Server 2000 which you can use ... as a backend database for a client-server application. ... end MDB files. ...
    (microsoft.public.windows.server.sbs)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)