What String I Can Use To Connect "Avs.Mdb" File From Computer Is In LAN Network

Question

0.00/5 (No votes)

See more:

This string I am using in text file to access my database in local computer. So how will modify it to use it from LAN Networked Computer.

C:\ProgramFiles\Data\avs.mdb

This Is my Connection code...

Dim CPath As String = Application.StartupPath & "\connector.txt"
Dim SR As StreamReader
Dim DataPath As String
Dim ConnStr As String

SR = File.OpenText(CPath)
DataPath = SR.ReadLine
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & DataPath & ";Jet OLEDB:Database Password=samparksimsjbps"

conn = New OleDbConnection(ConnStr)

If conn.State <> ConnectionState.Open Then
Try
conn.Open()
Catch ex As Exception
End Try
End If
Return conn

Posted 4-Aug-15 4:07am

Member 10899600

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Answer 1 · 2015-08-04T04:29:00

To be perfectly honest with you, I wouldn't do it.
Directly accessing a MDB file over a network is possible - it's not even difficult, just put the file in an accessible folder and path directly to it - but it's generally a very poor idea.

Access is not good at multi user access, and the only real reason for making a DB available on a network is to have several users accessing it at the same time. Every single time I've seen this done, it gives intermittent problems which (while fixable) take a lot of time and effort to work round.

Instead, consider installing SQL Server on one PC, and accessing the database via that. It's designed for multi user and will save you a huge amount of effort.

Michael_Davies · Answer 2 · 2015-08-04T04:35:00

Whilst I agree entirely with OriginalGriff here is what you are looking for.

The Datapath variable you use should contain the full path to the file, which if you are on a Windows network will be

\\put the machine name here\put the share name here\avs.mdb

So if the PC the file resides on has the name MyPC and you have shared the directory as DB then it will be:

\\MyPC\DB\avs.mdb

Hope it helps.

What String I Can Use To Connect "Avs.Mdb" File From Computer Is In LAN Network

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0