Access 2003 How to link tables on a peer to peer

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • cpStar
    New Member
    • Aug 2008
    • 18

    #1

    Access 2003 How to link tables on a peer to peer

    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\data base\name of backend. When I go in their Network from PC#1 the path to PC#2 is "\\Name2Office\ c-Name2\users\Nam e2\Documents\da tabase\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.
Working...