Solved

Remote Database Connection Through Vb

Posted on 2003-12-10
7
230 Views
Last Modified: 2010-04-17
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
0
Comment
Question by:teenapareek
  • 2
  • 2
7 Comments
 
LVL 2

Accepted Solution

by:
syed555 earned 250 total points
ID: 9911612
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.
 \\servername\sharedfolder\data\Mydatabase.MDB

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

0
 
LVL 69

Assisted Solution

by:Éric Moreau
Éric Moreau earned 250 total points
ID: 9917463
0
 
LVL 69

Expert Comment

by:Éric Moreau
ID: 10317109
split points between syed555 and emoreau
0
 
LVL 2

Expert Comment

by:syed555
ID: 10936468
split points between syed555 and emoreau
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Order table with macro 3 75
sumHeights  challenge 17 61
Replace a tag with sed 2 42
strDist challenge 35 84
This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now