How do I share Access DB on a network?

[Rick Wilson]

I have currently setup a peer to peer network at my church and we want to
share the access db out. What they have is one main db and several other
tables that all link back to the main db I think (as you can tell I'm not a
access pro). The desired outcome is to have everyone gain access to the db
via the net from their desktop pc's. When we map a drive from the clients pc
to the server and attempt to open the db it is looking for the path of the
db that resides on the server. Any help would be greatly appreciated.

Thanks Rick

 

[Matthew]

Go to the computer that can't connect. Under Objects, click tables. Right
click the link to the remote table and click "linked table manager". Check
the box to the left of the table name, and click OK. You can now browse
over to your server to find the other database.

Matthew

 

[George Avery]

tables that all link back to the main db <snip>

Rick,

First thing I always check is that linked tables are addressed through
fully qualified unc's and that they haven't been created by using a
mapped drive.

 

[John Nurick]

Hi Rick,

You'll need to split the database (unless you've already done so: I
can't quite tell from your description) so as to have all the data in
one (exceptionally, more than one) "back end" mdb file on the server,
and all the forms, queries, reports and code in a "front end" mdb, with
linked tables pointing at the back end.

If all the workstations use the same drive mapping you can set up the
linked tables in one copy of the back end (use the Linked table manager
to modify existing linked tables) using the relevant drive letter and
path (e.g. X:\Folder\Database\BackEnd.mdb). But it's sometimes better to
use the UNC path (e.g. \\ServerName\Share\Folder\Database\BackEnd.mdb)
because this is independent of drive mapping.

Either way, put a copy of the front end on each workstation.

 

[Rick Wilson]

Thanks everyone for your responses

Rick