Results 1 to 2 of 2

Thread: Connecting to MSACESS 2000

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Sep 2000
    Posts
    127

    Exclamation

    Dear all,
    I have been trying to connect to an msaccess2000, i'm using the dao3.51. It seems that it does not recognise the database, what should i do? Please shown me an example if if you have one, also...how to set the password if the database had one.

    Many thanks
    ASPWIZARD

    http://www.aspwizard.co.uk

  2. #2
    Fanatic Member crispin's Avatar
    Join Date
    Aug 2000
    Location
    2 clicks west of a Quirkafleeg...Cornwall, England
    Posts
    754
    You need DAO 3.6, and use the following example for the password access:

    Set gdbsDatabase = gwrkWorkspace.OpenDatabase(strDatabaseName, dbDriverNoPrompt, False, "MS Access;PWD=PASSWORDHERE")
    Crispin
    VB6 ENT SP5
    VB.NET
    W2K ADV SVR SP3
    WWW.BLOCKSOFT.CO.UK

    [Microsoft Basic: 1976-2001, RIP]

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