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.

2
Contributors
3
Replies
20
Views
4 Years
Discussion Span
Last Post by AndreRet
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.

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..

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
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.