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.
pardeep3dec
0
Junior Poster in Training
Recommended Answers
Jump to PostYou can go to this link for more reference.
http://www.connectionstrings.com/
http://www.daniweb.com/forums/thread272.htmlIn a nut shell you need this
Dim cn As OleDbConnection cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;_ Data Source=Path …
All 3 Replies
jbisono
51
Posting Pro in Training
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.
eloelo22
0
Newbie Poster
Dim cn As OleDbConnection
cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;_
Data Source=use ip address its better;")
eloelo22
0
Newbie Poster
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.