Cannot link tables in Access database

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?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<The problem is when I try to open the database, it will open but then errors because it cannot connect to the BE file.  >>

 Sounds like your app is split, and what you should have is the BE on the "Server" in the shared folder, and a FE on each of the stations.

 The path for linked tables to the BE's are stored hard coded, so if the path to the BE is different for different stations, you will get errors.

What you need to do is:

1. Create a mapped drive letter that is the same for every station pointing to the shared BE directory and set all the FE's to use that mapping.


2. Provide the ability to relink to the BE when the FE starts.  In that way, each user can use whatever pathing works for them.

and note that all users need full read, write, and delete privs for the shared directory where the BE is.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
PAMurilloAuthor Commented:
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.  

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.