Re: Access Database with Password

Hi Rolf,

Your connection string should be similar to this:
'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=database path;Persist
Security Info=True;User ID=UserName;Jet OLEDB:Database Password=userpassword

HTH,

Michael

"Rolf Hansen" <rhnnat@xxxxxx> wrote in message
news:42fa1d42$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> How can I connect to an Access Database with a password?
>
> I have created the Access2000 database using Access and created a password
> to be used for opening the database. When I use an ADOConnection Delphi7
> asks for Login ID (Administrator) and Password. Using the correct database
> password fails.
>
> Best regards
>
> Rolf Hansen
>
>


.

Relevant Pages

  • Concurrency Violation in DataSet Update ADO.NET
    ... Now I am developing Cheque Writing ... 'UPDATE DATABASE ... "TBKKTC") ... I use password to protect my Access database from ...
    (microsoft.public.dotnet.general)
  • Re: formatting columns
    ... This works for columns either to the left or right of the cell to be copied. ... >> I am preparing to set up a database in Access2002. ... >> have the time to set up the Access database so I must do ... >> my data entry into Excel. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Web Wiz Forums in New Subweb, Published with FP2003
    ... Whenever I download an Access database and prior to re-uploading I always do a compact and repair ... General rule once your forum is active, you should never download and then re-upload the ... FrontPage Resources, WebCircle, MS KB Quick Links, etc. ...
    (microsoft.public.frontpage.client)
  • Re: Failure of Linked table in Access...
    ... SQL Server database via an ODBC DSN. ... in the Access database with various forms and reports. ... error and all subsequent queries on the PROJ table fail. ... The table is one of many tables that are linked from SQL Server ...
    (microsoft.public.access.modulesdaovba)
  • ~~~~~~~~~~~~~~ WEB DATABASE ~~~~~~~~~~~~~~
    ... 2003 vb web database code ... access database and web hosting ... access database free web hosting ... add adventureworks database to web site ...
    (comp.protocols.snmp)