PAMurillo
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!
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!
/gustav