Click here to Skip to main content
15,939,243 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi! Is it possible to centralize my database in MS Access using 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:

connString5 = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\MISKRISTIAN\Desktop\kuwewe - Copy\queuingsystem\bin\Debug\HMOOPD_DB2.mdb"
Updated 10-Oct-17 16:22pm

1 solution

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
Share this answer
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=\\\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?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900