MSDE database security question...

From: B Andrei (bandrei@mediafax.ro)
Date: 10/29/02


From: "B Andrei" <bandrei@mediafax.ro>
Date: Tue, 29 Oct 2002 02:55:49 -0800


 I'm considering using a MSDE database for a desktop
database application. Actually is a new version of an
existing one, which has an access database. Because the
new database will have about 1 million records and the
need to query them in complex modes, an access database is
not a solution. I tested it with ADO and the response time
is too big.
 I installed MSDE 1.0 because the application is supposed
to work in Win 95 too, but I can't find any way to secure
the content of the database. I can simply stop the MSDE
engine copy the mdf and ldf files to another MSDE engine
with the default user "sa" and I can access it at record
level. The old version with an mdb database used a
workgroup file.
 Any help, suggestion and / or solution would be much
appreciated. Thank you...



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)