Access 2003 - Linked Tables?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My company recently upgraded all our systems from Access 2000 to Access 2003.
I have several databases that use linked tables. Some are linked to SQL
Servers, and others to Access databases or Excel ranges.

As an added bonus, our drive letters and such have changed. Some of my
linked tables do not work. However, when I go to Tools > Database Utilities >
Linked Table Manager, no linked tables show up. At all. For some projects, I
could have 10 or 15 linked tables. The window is completely blank.

Does anyone know what could cause this?
 
It is the drive letter changes that got you. It is best never to use drive
letters, instead, use the type of mapping you use when you connect to a
server folder:
Not
F:\Access\BackEnd\semirelation.mdb
But
\\MyServerName\Access\BackEnd\semirelation.mdb

All you need to do is re-establish your links.
 
MDW said:
As an added bonus, our drive letters and such have changed. Some of my
linked tables do not work. However, when I go to Tools > Database
Utilities >
Linked Table Manager, no linked tables show up. At all. For some projects,
I
could have 10 or 15 linked tables. The window is completely blank.
Click to expand...

Re-register accwiz.dll (the one located in the same folder where Access 2003
is installed)

Regsvr32 "path\ACCWIZ.DLL"
See
http://support.microsoft.com/?id=835519

You can use UNC pathnames rather than relying on mapped drives. Just use
Network Neighborhood to locate the backend.
 
Back
Top