Results 1 to 2 of 2

Thread: Access Workgroup file

  1. May 26th, 2000, 02:36 AM #1
    Guest
    How can I change the workgroup file (mdw) (run time) in vb6?

    ex.
    dim AppAccess as new Access.Application

    AppAccess.opencurrentdatabase "C:\Employee.mdb"
    AppAccess.visible = true


    The employee file need to joint a workgroup file.
    I would like to specify the path of my mdw file and user id and password through my custom dialog box.

    Any idea??? Thanks!
    Reply With Quote Reply With Quote
  2. May 26th, 2000, 02:59 AM #2
    JHausmann
    JHausmann is offline
    Frenzied Member
    Join Date
    Aug 1999
    Location
    Santa Clara, Ca , 95058
    Posts
    1,105
    Before doing opencurrentdatabase, try:

    AppAccess.DBEngine.SystemDB="your.mdw"
    AppAccess.DBEngine.DefaultUser="UserID"
    AppAccess.DBEngine.DefaultPassword="PasswordforaboveUser"
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width