Link to home
Start Free TrialLog in
Avatar of PAMurillo
PAMurilloFlag for United States of America

asked on

Cannot link tables in Access database

Everyone,
I have a simple peer to peer setup for an Access 2003 database.  The database is hosted on a Win 7 32bit computer.  I shared the folder and elected to use Password instead of Windows to managed shared folders on the host computer.  I can access the shared folder on the 2nd computer which is a Win 8.1 64 bit PC.  

The problem is when I try to open the database, it will open but then errors because it cannot connect to the BE file.  I tried logging in and re-linking the BE file while on the Win 8.1 PC using UNC and even a mapped drive (because various errors point to the path of the BE file looking for them on the host computer) but have not had any success.  It is like the Windows 8.1 computer cannot shake the path to the BE files that is only relevant to the host computer.  Any suggestions?  Is this clear?
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

You probably are missing to grant the necessary rights to both the share and the shared folder on the Windows 7 pc.

/gustav
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of PAMurillo

ASKER

Hi Jim,
It had been a while since I setup a split Access database.  The permissions for the folders on the host were good, it was the front-end that I needed to tweak.  

Thanks!