Re: automatically generate access database with password

From: Andreas Schmidt (a_j_schmidt_at_rocketmail.com)
Date: 01/21/04 

Date: Wed, 21 Jan 2004 11:27:46 +0100

"Michael" <michael_KANWEG_@bleijerveld.nl> schrieb im Newsbeitrag
news:400d5623@newsgroups.borland.com...
> Is it possible to give an automatically generated access database a
password

Use the following Connection String:

'Provider=Microsoft.Jet.OLEDB.4.0;'+
'Data Source=\somepath\mydb.mdb;'+
'Jet OLEDB:New Database Password=secret;'

hth
Andreas 

--
Database Explorer for ADO (Freeware)
http://scorpius.spaceports.com/~adodesk/adodeskexe.zip
http://mitglied.lycos.de/ajs/adodeskexe.zip

Relevant Pages

  • Re: ADO MS Access
    ... There is no Jet system parameter available. ... I use Jet Oledb Database pasword. ... > Database" parameter of the connection string to set the location of your ...
    (borland.public.delphi.database.ado)
  • Re: Delete rows created when Error 3159 "Not a valid bookmark" enc
    ... >> It sounds like corruptions in your database. ... >> HTH ... >> Van T. Dinh ...
    (microsoft.public.access.forms)
  • Re: problems working with dates
    ... database - except what you tell us. ... manipulate the interger fields acoording entries in the string field. ...
    (microsoft.public.access.gettingstarted)
  • Re: VBA in Excel & ADO: some problems
    ... > I know how to specify userid and pass in ADO, but how can I add password ... Yes you can connect to the same database more than once. ... >> string, i.e. the Jet OLEDB:System Database parameter. ... >> HTH ...
    (microsoft.public.excel.programming)
  • Re: work with protected msaccess database through ado
    ... Remove "Password=XXX" from connection string and add "Jet OLEDB:Database ... Vassiliev V. V. ... MS Jet and Interbase ... > I lookin for a way to work with protect the MsAccess database through ADO. ...
    (borland.public.delphi.database.ado)