Results 1 to 2 of 2

Thread: Data Control and Access 2-Access 97

  1. #1

    Thread Starter
    New Member
    Join Date
    Jun 1999
    Location
    Genova- Italy
    Posts
    4

    Post

    How can I bind a data control(in VB 6) to Access 2 and Access 97 (password protected) database?
    I use the fallowing statement
    DataCtl.databaseName = GB_Database (path and name of file.mdb)
    What have I to change?
    Can someone help me??

  2. #2
    Addicted Member
    Join Date
    Apr 1999
    Location
    Freeport
    Posts
    204

    Post

    I'm not sure about VB6 but in VB5 I'm using both data control and DOA. To make sure my datacontrol will open the databasrname I first use this statement before I set up a datacontrol. Something like this:
    dim dbs as database
    Set dbs = OpenDatabase(Database Path, False, False, "MS Access;pwd=passwordname")
    dtaName.DatabaseName = "database Path"
    dtaName.RecordSource = "tablename"
    dtaName.Refresh

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