Results 1 to 5 of 5

Thread: Connect to a remote MS Access database in vb6

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2011
    Posts
    688

    Connect to a remote MS Access database in vb6

    Hi

    I have below connection to save data on Local Computer .How to Connect to a remote MS Access database in vb6

    cnn1.Provider = "Microsoft.Jet.OLEDB.4.0;"
    cnn1.Properties("Jet OLEDBatabase Password") = pword
    cnn1.ConnectionString = App.Path & "\Data\Sample.mdb"
    cnn1.Open

    Thanks
    Last edited by Jagjit; Mar 9th, 2021 at 02:43 AM.

  2. #2
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    5,872

    Re: Connect to a remote MS Access database in vb6

    Can you explain what in this case a remote database is?
    Is the MS Access file located:
    1. on a network share
    2. somewhere on the local network
    3. a computer on the internet?

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Dec 2011
    Posts
    688

    Re: Connect to a remote MS Access database in vb6

    Hi

    Somewhere on the local network

    Thanks

  4. #4
    PowerPoster Arnoutdv's Avatar
    Join Date
    Oct 2013
    Posts
    5,872

    Re: Connect to a remote MS Access database in vb6

    In that case I think I would first try a local network share.

  5. #5
    Hyperactive Member
    Join Date
    Jul 2020
    Posts
    370

    Re: Connect to a remote MS Access database in vb6

    Code:
    Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\shareName\folder\myDatabase.mdb;User Id=admin;Password=;

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