I'm having trouble connecting to a database file on another PC. In this case, my PC is the client.
- Windows 7 32-bit on both PC's.
- Same Workgroup
- Connection verified using cmd (PING)
- Connected using hub (straight through)
- Workgroup status: Joined
- MS Access 2007 as database app.
My connection string:
Con.Open "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=\\192.168.1.1\SERVERPC\C:\MYDB.accdb; Persist Security Info=False;User Id=Admin; Jet OLEDB:Database Password = mypassword"
The IP address and database locations are correct.
I'm recieveing THIS error.
Is my connection string wrong or is it on the hardware?