Dan Donlon said:
I am trying to make a database that is accessed by multipule users at one
time. I was told that I need to make a Front End/Back End database. Any
ideas where I can find any information on going about this? All the books
and websites I found do not say anything regarding this. I am grateful for
any help....
There is a wizard, but I prefer to do it manually myself.
Just make a copy of your database and give the copy whatever name you want
for the back end file. Open the back end file and delete all objects
except the tables. Then open your front end file (the original) and delete
all of the tables.
Place the back end file where you want it on the network. Then, in the
front end file go to File - Get External Data - Link Tables. Browse to the
location where you placed your back end file making sure you go through
Network Neighborhood - Entire Network (don't use a mapped drive letter).
When the list of tables is shown press "Select All" and [OK]. You're
done.
Since you didn't use a mapped drive letter your links will be to a UNC path
like \\ServerName\ShareName\BackEnd.MDB This path type should work for all
users on your network as long as they have permissions to that folder. If
you use a mapped drive letter, then all users would have to have that
location mapped identically on their PCs or you would need to add a utility
for them to be able to relink to the tables using a different link-path.
