1,105,310 Community Members

Sharing Database to Another PC

Member Avatar
jovstudios
Junior Poster in Training
53 posts since Mar 2013
Reputation Points: -3 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Hello Guys ..

I want to understant how to share my Database to the other Computer USing IP address..

Anyone can show me the code for connection.. This is my Code,

acd.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\POS.mdb;Persist Security Info=False"
    acd.CursorLocation = adUseClient

where can i put the ip in my code to connect my database to the other pc.. thanks.

Member Avatar
AndreRet
Industrious Poster
4,492 posts since Jan 2008
Reputation Points: 362 [?]
Q&As Helped to Solve: 499 [?]
Skill Endorsements: 24 [?]
 
0
 

This should work -

acd.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.168.0.10\YourPCNameHere\POS.mdb;Persist Security Info=False"
    acd.CursorLocation = adUseClient

Make sure that the database is under your c: drive, not in any folders. That will eliminate user rights...

Also change the ip address to what you have for your server.

Member Avatar
jovstudios
Junior Poster in Training
53 posts since Mar 2013
Reputation Points: -3 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

Sir i put my POS folder Under My C: Is this Correct?

 acd.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\203.215.117.121\diaz-31ba39b6c1\POS.mdb;Persist Security Info=False"

But Invalid Path..

Member Avatar
AndreRet
Industrious Poster
4,492 posts since Jan 2008
Reputation Points: 362 [?]
Q&As Helped to Solve: 499 [?]
Skill Endorsements: 24 [?]
 
0
 

I haven't worked on access for a long time. try the following 2 solutions, one of them will work...

acd.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\203.215.117.121\POS.mdb;Persist Security Info=False"

''OR

acd.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\203.215.117.121\c:\POS.mdb;Persist Security Info=False"

''OR

acd.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\203.215.117.121\c\POS.mdb;Persist Security Info=False"

''OR

acd.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\203.215.117.121\diaz-31ba39b6c1\c:\POS.mdb;Persist Security Info=False"

''OR
acd.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\203.215.117.121\diaz-31ba39b6c1\c\POS.mdb;Persist Security Info=False"

after the open statement, add the following...

acd.CursorLocation = adUseServer
You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article