Re: Database securing problem

From: B Andrei (bandrei@mediafax.ro)
Date: 11/05/02 

From: "B Andrei" <bandrei@mediafax.ro>
Date: Tue, 5 Nov 2002 00:42:17 -0800

    I wish I could, but the application is for
distribution and it should work on all Windows platforms,
including 95 and 98. So this is not a solution to my
problem.
    That's the reason for using MSDE 1.0 and not the new
version. I've searched everywhere and I can't imagine that
Microsoft didn't included not one single way to protect
the content of a database, any sort of encryption (even in
Access you can use the workgroup file and this kind of
problem is solved).
    I mean... all you must do to access the content of a
database is to stop the MSDE, copy the mdf and ldf files
to your own MSDE of SQL Server and attach them, and you
have access to everything with your own admin (sa user).
    The only solution I currently have is to encrypt the
sensitive content myself in every single record!

>-----Original Message-----
>Place it on a Win2k or XP machine and set the file
permissions.
>
>"B Andrei" <bandrei@mediafax.ro> wrote in message
>news:470501c283eb$cefc7540$37ef2ecf@TKMSFTNGXA13...
>> I'm running a MSDE 1.0 on a windows 98 machine.
>> Whatever user permissions for my database I set, another
>> person with file access can simply copy the database
(mdf
>> and ldf files) to another sql server that he owns (so
that
>> he knows the passwords) and attach my database
>> successfully.
>> I'm planning to distribute a desktop application
with
>> an MSDE engine for database support and I can not find
any
>> solution to secure the content of it.
>> Please help... if any of the ms guys can give me a
>> suggestion. The previous version of my application used
an
>> Access database with a workgroup file and it worked very
>> well, but now I can't find something to prevent someone
to
>> copy the database without detaching it and browsing the
>> content.
>>
>> Regards,
>> Andrei B.
>>
>
>
>.
>

Relevant Pages

  • Re: Data corruption with SQL server installed
    ... I noticed that the rogue Primary key that appeareed with the .AddNew method ... The installation of MSDE comes after the installation of MDAC 2.8, ... you could create an empty database and import everything into ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Put database on Internet
    ... > Once you will be able to connect to MSDE or to SQL-Server, ... > and ADP in the same time as frontends to your database. ... >> will be able to serve as SQL server. ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.externaldata)
  • Re: Connect to Access Data from various regional locations
    ... All users will be connecting via broadband. ... When using MSDE ... > Dim rf As DAO.Recordset ... > There is a wizard to split your database into a FE and a BE; ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Using vfoledb with webservices?
    ... MSDE database can handle at full speed. ... capabilities of Microsoft Access or, in the reasonable opinion of Microsoft, ... and unless Licensee Software requires your customers ...
    (microsoft.public.fox.programmer.exchange)