Member Avatar for pardeep3dec

Hi friends,
Can u tell how can i connect to ms access table from a remote pc within LAN. I want to make a small programme for database manipulation on LAN. Whose database will be stored on a single pc and another can access that data from remote pc within LAN. Please help.

  • 3 Contributors
  • 3 Replies
  • 130 Views
  • 4 Weeks Discussion Span
  • Latest Post Latest Post by eloelo22
Member Avatar for jbisono

You can go to this link for more reference.

http://www.connectionstrings.com/
http://www.daniweb.com/forums/thread272.html

In a nut shell you need this

Dim cn As OleDbConnection
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;_
Data Source=Path to your database;")

path to your database could be the computer that has the share database. be sure to give the correct rights to the database probably read and write. and of course make sure all users in the local network has access to the folder which the DataBase is.

Hope that helps regards.

Member Avatar for eloelo22

Dim cn As OleDbConnection
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;_
Data Source=use ip address its better;")

Member Avatar for eloelo22

or why dont you try to establish a data source use the data option in the toolbox when you connect the connection string will be available simply copy it

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.