Centralizing my program

Question

0.00/5 (No votes)

See more:

Hi! I'm having trouble on making my program, a queuing system, centralized. It is going to be used by 5 different computer workstations.

My question is, do I need to copy the source code of the program I'm currently developing to the other 5 computers? Or do I only have to setup the program using the install shield? My other problem is how can I use a single database, the one that the system currently uses, on the other 5 computers?

I'm currently using VS2012 and MS ACCESS 2007 as my database. Thanks!

What I have tried:

connString6 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\IPAdd\share\C:\Users\PCName\folder\database.mdb"

Posted 16-Oct-17 22:06pm

noob_noob

Updated 16-Oct-17 22:24pm

Add a Solution

Comments

Richard MacCutchan 17-Oct-17 4:17am

You certainly need your database on a central server if you want to share it between workstations. Check the Access documentation for the procedures you need to use. And use InstallShield (or similar) to install your program on multiple workstations. Copying alone can leave vital components missing.

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 · Answer 1 · 2017-10-16T22:24:00

You don't need to copy the source code, just the install program should do: that is it's job! It installs your application and all the files it depends on on each computer that needs to run the app.

But ... don't use Access. It's not designed for multiuser access and while it is possible to use it that way, it has given nasty problems every time I've seen it done.
Use a Server based database like SQL Server, or MySQL instead - provided your code is well written, it should be just a case of changing OdbcConnection to SqlConnection or MySqlConnection; OdbcCommand to SqlCommand or MySqlCommand; etc. You will need to change the connection string, but that should be in a configuration file anyway so that should be no problem at all.
The database system will need to be installed on the server, and the database itself added to the engine.