Remote Database Connection Through Vb

I have a MsAccess Database on Server and the client wants to connects the database. The Database is not sharable. How can i connect it usiing Vb
Who is Participating?
syed555Connect With a Mentor Commented:
1st  step is to share the drive or folder of the server on which your access database is residing. once you share, client should be able to access the database browsing through network.

2nd step to connect database from VB.
there are no of methods to do so.
one way is to create an Odbc connection from windows control panel of clinet.
ODBC will map the database with network path.

code to connect from VB
Dim cn as new Adodb.Connection
Cn.Open "DSN=YourDSN;UID=admin;PWD="

Éric MoreauConnect With a Mentor Senior .Net ConsultantCommented:
Éric MoreauSenior .Net ConsultantCommented:
split points between syed555 and emoreau
split points between syed555 and emoreau
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.