How to connect Database that stored on Server from Client?

Question

0.00/5 (No votes)

See more:

Hi,

I have One Vb.Net Application, It Use M. S. Access 2003 Database. Currently It Run Perfactly on Single PC.

I want to convert said app. into Server - Client Application.

My Basic Question is, How can we do Following

Can anyone Guide (With Example Code) for

(1) Connection to Database which is stored on server,
Currently I use Data Source=|DataDirectory|Db.mdb
(2) Access Database ( Like Insert, Update and Delete ).
(3) Fetching Data ( Fill Datagrid with data from Server into Client )
Sorry but I am not Understand How to Code.

Thanks

Posted 7-Sep-11 3:04am

s1a2b3

Updated 7-Sep-11 3:06am

v2

Add a Solution

1 solution

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)

Wendelius · Accepted Answer · 2011-09-07T03:16:00

Solution 1

Just:
- store the access file in a network share
- modify the connection string to point to the file in the network (possibly use UNC)

And off you go. The program (excluding the connection string) remains the same.

For the connection string, see: http://www.connectionstrings.com/access[^] /Network location)

Now, this isn't going to be a client server program. It still is a program using a single shared file. If you really want to convert this to client server then I suggest that you move on to Sql Server instead of Access. You can download an Express edition for free: http://www.microsoft.com/sqlserver/en/us/editions/express.aspx[^]

Posted 7-Sep-11 3:16am

Wendelius

Comments

s1a2b3 7-Sep-11 13:06pm

Ok, Thanks So Much. . . . as you suggest I want to move to SQL Server but I am New to it. Suggest Me Good SQL & Vb.Net Step by Step Guide (Server-Client) so I can try to Convert application into Client Serverbase.

Wendelius 7-Sep-11 13:14pm

Glad it wasd helpful :)

I'm sorry but I cannot really suggest any good book about that because I haven't been looking such books for a while. However I had a quick look at Amazon and this looked promising. But as said this is not a suggestion, just observation:

http://www.amazon.com/Beginning-Express-Database-Applications-Developer/dp/1590595238/ref=sr_1_4?ie=UTF8&qid=1315415417&sr=8-4[^]