access your data base stored on server from any PC using C#

Question

0.00/5 (No votes)

See more:

hello,
i used c# language and database by Microsoft Access , i finished my project .
but i have a server and i want to put the data base on that server and use it by my project from any PC.
i think about changing the data source for my data base in the project and write the path for my server just, it is true or not ???
plz help me .

Posted 3-Jul-13 20:16pm

loai_maane

Add a Solution

Comments

Thanks7872 4-Jul-13 2:20am

e.g. Google have database on server and you can access gmail from any PC.Its that simple.Have you tried something?If so,whats the issue?

Prasad Khandekar 4-Jul-13 2:27am

Hello Loai,

Putting your access database in a shared folder on the server should allow multiple clients to access it.Though you will be limited to around 25 concurrent editors, and this scheme is suitable for intranet only.

The access database is not really suited for this purpose, consider using SQL Server, MySQL, Oracle or similar database.

Regards,

loai_maane 4-Jul-13 2:31am

thnx prasad ,
if i use sql server what i should to do if i want to use my database from any PC ??

Prasad Khandekar 4-Jul-13 3:47am

Hello Loai,

You probably need to change your connection string only. But do some testing to makes sure that there are no issues in your queries and data types.

Regards,

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)

OriginalGriff · Accepted Answer · 2013-07-03T20:19:00

Solution 1

With Access, all you have to do is put the file into a server folder that you can access from the remote PC, with read and write access - a shared folder, is all.

However, be aware that Access is not a particularly good database to use in a multi-user environment (the main reason for sharing the file) - if that is what you want to do, then you would be better off switching to SQL Server or MySql as they are designed fro just that.

Posted 3-Jul-13 20:19pm

OriginalGriff

Comments

loai_maane 4-Jul-13 2:37am

if i use sql server what i should to do if i want to use my database from any PC ??

OriginalGriff 4-Jul-13 3:11am

All the PC's connect to the SQL server instance - it then handles the file storage as servers the query responses to your software. That's what it's meant for - so that multiple users can access the same DB data.