Results 1 to 2 of 2

Thread: Logon to Access DB ?

  1. #1
    Guest

    Post

    How do I log on to an Access database with password protection ? I would appreciate it if anyone can help me.

    P.s. I do not want any GUI for this application as it is supposed to be an automated process. Ie; no user input is allowed.

  2. #2
    Serge's Avatar
    Join Date
    Feb 1999
    Location
    Scottsdale, Arizona, USA
    Posts
    2,744

    Post

    You can use ADO to do that, as long as you know the UserID and the Password:

    Code:
        Dim cn As New ADODB.Connection
        
        cn.Provider = "Microsoft.Jet.OLEDB.3.51"
        cn.Open "D:\Microsoft Visual Studio\VB98\Nwind.mdb", "MyLoginID", "MyPassword"
        
        rs.Open "Select * from customers", cn, adOpenStatic
    
    ''''''And so on...

    Regards,

    ------------------

    Serge

    Software Developer
    [email protected]
    [email protected]



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