ODBC Link specific to workstation issue

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

I have an Access 2000 application that using an ODBC link
to access information from a central DB server (e.g.
Oracle). My plan was to create a version that multiple
users could use.

The issue is that I have to link the central db tables
specifically from each workstation in order for the link
to work correctly. I thought as long as I had the
appropriate ODBC driver set up on each workstation, that I
could just have multiple users access the one .mdb file
that had the central db tables linked? When I tried to do
this, I get an ODBC error. The only way that I could
resolve it was to go in and link the tables from each
workstation. Needless to say, this is a maintenance
intensive issue given any changes. Is there something
that I am missing that would allow me to create one
version with the link and use it on multiple workstations?

Thanks,

Dave
 
Correct me if im wrong but it sounds like your moving from a client only db
to a server/client setup. If this is the case then your easiest route is to
take one of the client interfaces, open and correctly link the tables to the
server db. Now copy paste the new correct client over to the workstations.
 
What you are suggesting is exactly what I have done. It
works correctly on the initial workstation that I have
done the link to the central db. When I copy that mbd
file (or access it from the network) from another
workstation it will not work (ODBC error). It only works
from the workstation that did the actual table link from
within Access.

If I take that exact same file, relink the tables from one
of the other workstation that previously did not work....
then it works fine..

Dave
 
Back
Top