Centralizing database using VB.NET

Question

0.00/5 (No votes)

See more:

Hi! Is it possible to centralize my database in MS Access using vb.net? I'm currently using Visual Studio 2012 and MS Access 2007. Below is my connection string if you need to understand it a bit more. Thanks!

What I have tried:

VB

connString5 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\MISKRISTIAN\Desktop\kuwewe - Copy\queuingsystem\bin\Debug\HMOOPD_DB2.mdb"

Posted 10-Oct-17 15:37pm

noob_noob

Updated 10-Oct-17 16:22pm

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)

Atlapure Ambrish · Accepted Answer · 2017-10-10T16:22:00

Solution 1

Yes it is possible, you should simply use UNC/shared path for source in your connection like in below example.

provider=Microsoft.Jet.OLEDB.4.0;data source=\\COMP_NAME\c$\database\db1.mdb

provider=Microsoft.Jet.OLEDB.4.0;data source=\\COMP_NAME\Database\db1.mdb

Posted 10-Oct-17 16:22pm

Atlapure Ambrish

Comments

noob_noob 10-Oct-17 23:13pm

Hi! what is "c$"'s purpose?

Atlapure Ambrish 11-Oct-17 2:39am

c$ is the drive name on the machine where the database is kept

noob_noob 12-Oct-17 1:42am

connString5 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\192.168.1.86\share\C:\Users\MISKRISTIAN\Desktop\kuwewe - Copy\queuingsystem\bin\Debug\HMOOPD_DB2.mdb"

Is this connection string right? I really don't have any idea what I'm doing right now. Thanks for the help!

Atlapure Ambrish 12-Oct-17 2:01am

The connection string is absolutely fine (just check if you are able to access the network path), what problem are you facing now?

noob_noob 12-Oct-17 2:09am

I tested the connection but an error box appeared that said "Not a valid file name." What does that error mean?

Atlapure Ambrish 12-Oct-17 2:45am

Can you try opening the mdb file in access and save as .accdb and try to connect?

noob_noob 12-Oct-17 4:13am

Hi! I tried to save the database to .accdb but it still produced an error that said "'\\192.168.1.86\share\C:\Users\MISKRISTIAN\Desktop\kuwewe - Copy\queuingsystem\bin\Debug\HMOOPD_DB3.accdb' is not a valid path. Make sure that the path name is spelled correctly..."

noob_noob 12-Oct-17 4:25am

and that IP address is the address of the PC I'm working on right now. Is that why there is an error every time I test the connection?

Atlapure Ambrish 12-Oct-17 5:56am

If it is the machine your working on then you don't need the shared path, you should just use normal path e.g.: c:\abc.mdb

noob_noob 13-Oct-17 1:25am

So that means that I have to change the connection string path on the other computers that will use my system to make my database centralized?

Atlapure Ambrish 13-Oct-17 2:26am

yes correct, if you are deploying your application on other machine and keeping database on your machine, then you have use shared path for database on other machine.

noob_noob 13-Oct-17 22:44pm

so this connection string:
connString5 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\\192.168.1.86\share\C:\Users\MISKRISTIAN\Desktop\kuwewe - Copy\queuingsystem\bin\Debug\HMOOPD_DB2.mdb"

is the string I'll be using on the other computers as their connection string?