Results 1 to 3 of 3

Thread: access with password protection

  1. #1

    Thread Starter
    Lively Member nutstretch's Avatar
    Join Date
    May 2000
    Location
    UK
    Posts
    85
    Can I put a password onto a database and still be able to call it through VB6

    Heres hoping

    nuts
    if at first you don't succeed, drink the rest of the bottle and loop to the same place tomorrow

  2. #2
    Lively Member Dr_Evil's Avatar
    Join Date
    Mar 2000
    Location
    Columbus, OH
    Posts
    105
    If you are using ADO this allows you to open a password protected database.
    Code:
    Dim cn as ADODB.Connection
    Set cn = New ADODB.Connectioncn.Provider = "Microsoft.Jet.OLEDB.3.51"
    
    cn.ConnectionString = "Data Source=D:\db1.mdb;Jet OLEDB :database password=your_password"
    cn.CursorLocation = adUseClient
    cn.Open
    Dr_Evil
    Senior Programmer
    VS6 EE
    VS.NET EA

  3. #3

    Thread Starter
    Lively Member nutstretch's Avatar
    Join Date
    May 2000
    Location
    UK
    Posts
    85
    thanks i'll try that
    nuts
    if at first you don't succeed, drink the rest of the bottle and loop to the same place tomorrow

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width