Linking tables

[CC]

I have created a database that includes a linked table -
which contains employee data- such as hire date, Id's etc.
There will be several users using the database and they
all have access to the database that is the source of the
linked table as well as the new database being created.
When they try and go into the form that contains the
linked data they can not get in.- Error Executing Command
message pops up. They have access to everything else but
that. I tried to get into the query from their machine and
it says it can not find /pdcnwtn1//123/. I deleted the
linked table from the PC and "re-linked" it- which then
allowed access to the data in the linked table. Do I have
to do this to everyone who will be using this database or
is their an easier way of doing this?

 

[MacDermott]

If you enjoy coding in VBA, or if you expect this sort of problem to recur,
you can write code to relink your "back-end" tables. You can find some demo
code at www.mvps.org/access.

If it's a one-time deal, though, or you don't want to get into coding, just
do it on each machine.

HTH
- Turtle

 

[Van T. Dinh]

"/pdcnwtn1//123/" looks to be a very strange path to me.

Does each user have a copy of the Front-End mdb on his / her desktop?

Have you done a Compact & Repair before distributing the Front-End?

You can set up code to re-link the Tables. See The Access Web article:

http://www.mvps.org/access/tables/tbl009.htm

 

[CC]

I re looked at the path and the path is P:\Paytrack -
2003.mdb and the other table from the same database is set
up as \\pdcnwtn1\paytrack\Paytrack - 2003.mdb.
Currently only one user has a shortcut to the database on
their desktop- all users will do the same.
I have ran a compact & repair before distributing.- Thank
you for your help this is greatly appreciated and I will
look at the web site listed. Thanks

 

[Van T. Dinh]

Yep. The paths look more familiar.