0

I'm having trouble connecting to a database file on another PC. In this case, my PC is the client.

Using:

  1. Windows 7 32-bit on both PC's.
  • Same Workgroup
  • Connection verified using cmd (PING)
  • Connected using hub (straight through)
  • Workgroup status: Joined
  1. 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?

3
Contributors
2
Replies
6
Views
3 Years
Discussion Span
Last Post by jhai_salvador
0

A share path is usually specified as

\\MACHINE\SHARE\PATH\FILE

where SHARE is defined on the sharing machine and is never specified as an actual device like C:. If an administrative share is used, C: might be replaced with C$. In any case, if you can't browse to the file using the share path then you won't have access to it through the application. So try typing

\\SERVERPC\C$

into the address bar of an explorer window and see if you can browse to the folder containing MYDB.accdb.

0
  1. If you shared your ms access database, it might look something like this;

\192.168.1.1\SERVERPC\MYDB.accdb

and NOT \192.168.1.1\SERVERPC\C:\MYDB.accdb;

Try to open \192.168.1.1\SERVERPC\ and see if the database exist or not.

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.