Linked files from network drive

  • Thread starter Thread starter Tony Girgenti
  • Start date Start date
T

Tony Girgenti

Hello.

We are using Access 2000 to open a database with linked files. When i
install the Access MDB file on the server I link to other MDB files while on
the server using the manual linking (File/Get External Data/Link Tables) to
D:\XXX.

When i go to the workstations, how do i install the same MDB file ?

I seem to have a problem because the original link at the server used D:\XXX
and the work stations are mapped to the server's D:XXX as W: and i get a
message saying it can't find the links.(I can't remember the exact message,
but i can get it if needed)

Any help would be gratefully appreciated.

Thanks,
Tony
 
You can use UNC naming rather than the drive mappings. You can use the
linked table manager (Tools, Database Utilities)(put a check at the bottom
of the dialog) and locate the backend via My Network Places. That'll use
the UNC name i.e. \\servername\share\path

Once the frontend has the tables linked, you just need to copy the frontend
to the users. You don't have to repeat the linking at each station, because
the link information is stored in the frontend.
 
Hello Joan.

That sounds easy enough. When you say "copy the frontend to the users", how
would you do that ? Actually copy the MDB file to their computer ?

Thanks to Joan and JimS for their replies.

Tony
 
Back
Top