Split DB-How do I set up users to the Back-end?

[Dan]

Help. I have split my DB into front- and back-end on the
server and it works just fine on my PC. Now, do I make
copies of the front-end and send to each user? How do I
connect each user's front end copy to the server at the
back-end when it's been installed on their PC? I'll first
make sure they are mapped to the back-end, but then what?
Thanks for any help!
Dan

 

[Dan]

-----Original Message-----
Dan,

Replies inline below...

Gary Miller

what?

If you use mapping, you need to make sure that the mapped drive letters are
identical on each computer. A preferred way is to do your initial linking on
yours using UNC mapping which just relies on the backend computer's name.
Ex: //Server1/Databases/YourDatabase.mdb. This should allow all computers to
find it on the network with no need for mapping.

You really won't need to do anything else except maybe help them setup a
desktop shortcut if they want one. They should be able to open their front
end and if the mapping and linked paths are correct it should connect
nicely.

Gary Miller


.Gary: Your response showed up in my e-mail so I

responded there.... Sorry!!!
Is there a procedure available for setting up the UNC
mapping on the front-end file as you suggest? Sort of the
same question I asked before, only more concise. sorry
again for the repetition. thanks, Dan

 

[Gary Miller]

Dan,

Use the Linked Table Manager's browse function. Instead of browsing to a
drive or folder, browse your Network Neighborhood, find the computer that
the back end will be on and then drill down to the folder where your back
end is and select it there. This should fill in the correct UNC.

Gary Miller

 

[Dan]

OK... I have a copy of my FE and will try that tomorrow on
another user's PC. I'll be using a copy of the FE file on
my PC after I connected it to the BE. That shouldn't be a
problem?
Dan

 

[Gary Miller]

Not as long as the relative paths are the same. If not, just use the Linked
Table Manager to point using his path.

Gary