By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,671 Members | 1,278 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,671 IT Pros & Developers. It's quick & easy.

Access 2003 How to link tables on a peer to peer

P: 18
My client doesn't have Access, so I installed the runtime version & they are on a peer to peer (only 2 PCs). I'm using an mde for the frontend & a mdb for the backend.

This is the first time I have placed my database on a peer to peer. My other clients are all on client/server. I have placed the frontend & the backend on PC #2 & it works fine. But when I try to access the database from PC#1 it obviously can't find the backend because it's looking for c:\users\User#1\documents\database\name of backend. When I go in their Network from PC#1 the path to PC#2 is "\\Name2Office\c-Name2\users\Name2\Documents\database\name of frontend"

My question is how do I link the tables on my laptop before I create the mde so both users will be able to use it? Is it even possible to do from my laptop?

Thanks in advance for any help or suggestions.
Mar 22 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.