No linked table manager after installing 03

[tom]

OK, I just installed Access 2003 and it works. Better
yet I still have Access 97 working.

However, I dont have a linked table manager which is
a very important feature for me and I can't even find the
the new Northwind Database and all sorts of other
stuff. I tried to run the install disk again, but this is a very
tricky operation as I cannot lose Access 97 until I
complete the upgrade of my application and reinstalling
gives different command options.

 

[Guest]

Tom,
Sounds like some of the options were not installed. If you resinstall will
the complete install (all options) the Linked table manager should come along
for the ride. Hope that helps.

 

[j_beverly]

OK, I just installed Access 2003 and it works. Better
yet I still have Access 97 working.

However, I dont have a linked table manager which is
a very important feature for me and I can't even find the
the new Northwind Database and all sorts of other
stuff. I tried to run the install disk again, but this is a very
tricky operation as I cannot lose Access 97 until I
complete the upgrade of my application and reinstalling
gives different command options.

I just installed Access 2003 also. Regular auto-install - no special
procedures... and the Linked Table Manager is there.

Tools > Database Utilities > Linked Table Manager

Maybe it was in a differend location in '97, I don't remember but are
you sure it's not there?

 

[dbahooker]

yes; it was under addins in Acc97; but it's under 'database utilities'
in 2000+

for the record; you should be using Access Data Projects and not linked
tables.
Linked tables are a maintenance nightmare.

are you also going to write code to update the connection strings for
your sql passthrough queries?

if you're not using SPT queries; then you should be.
if you are using SPT then you should be using Access Data Projects.

-Aaron

 

[Pieter Wijnen]

I don't remember exactly where, but there's a registry entry for accwizz.dll
that incorrectly points to c:\Windows\system32\accwiz.dll
this must be changed to the location off accwiz.dll in Office11
ie something like
C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE11\ACCWIZ.DLL

HTH

Pieter

 

[Pieter Wijnen]

Found it!

http://support.microsoft.com/default.aspx?scid=kb;en-us;835519

Pieter