linked tables

  • Thread starter Thread starter mpm
  • Start date Start date
M

mpm

I have a database that is split into a front end and a
backend. The backend I want to be able to put in a
shared folder that everyone on my network can see. Then
I can put the front end on the other computers that will
use the database. I made a package to install Access
Runtime on the other computers, but how do I tell the
front end where the back end is. Our previous IT guy
quit, but he has a similiar database that has the backend
on a specific shared drive letter. In order for his to
work the client computers must have a mapped drive to
this folder and assigned the correct letter. How does
this work and how can I get my database to do the same?
Any help is greatly appricated!!
 
mpm said:
I have a database that is split into a front end and a
backend. The backend I want to be able to put in a
shared folder that everyone on my network can see. Then
I can put the front end on the other computers that will
use the database. I made a package to install Access
Runtime on the other computers, but how do I tell the
front end where the back end is. Our previous IT guy
quit, but he has a similiar database that has the backend
on a specific shared drive letter. In order for his to
work the client computers must have a mapped drive to
this folder and assigned the correct letter. How does
this work and how can I get my database to do the same?
Any help is greatly appricated!!
Click to expand...

Create the link by using a UNC path (\\ServerName\ShareName). Then it will work on
all PCs on your network without having to set up drive letters. Just go through
Network Neighborhood - Entire Network when creating the links.
 
mpm said:
end file in a shared folder on my computer and I install
the package on another computer in the same network, I
can open the access runtime, but when I try to access a
table in the backend file, it can't find it. In what
program do I create the UNC link that you talked about?
Windows Explorer? Or if I map a drive to that shared
folder is that all I need and the access runtime will
search the network links that are in the network
neighborhood and find the link automatically? Thanks
again!!
Click to expand...

On your computer relink to the tables in the back end but go through Network
Neighborhood to do so. If your computer on the network was named "mpm" you
would end up with a link defined as \\mpm\FolderShareName. That link would work
on any computer on your network. All you would have to do is give people a copy
of the front end and it will point to your shared folder using the same path.
 
Back
Top