SQL 2000, Server 2003, Access XP

[Janet]

I had an Access XP connected through linked tables to an
SQL7 db running on NT4 and everything worked great. I've
just migrated to SQL 2000 on Server 2003 and the linked
tables are now blank. Yet when I go to the sql database,
there are thousands of records.

Probably something to do with MDAC? I've tried
reinstalled 2.8, then reinstalled 2.6

Appreciate some help.

Janet

 

[janet]

What finally worked was uninstalling Office XP,
resinstalling, then re-applying svc pk 3.

Wierd or what?

jb

 

[Tony Toews]

I had an Access XP connected through linked tables to an
SQL7 db running on NT4 and everything worked great. I've
just migrated to SQL 2000 on Server 2003 and the linked
tables are now blank. Yet when I go to the sql database,
there are thousands of records.

Stupid question. Have you changed the connection string on the linked
tables to point to the new SQL Server server and database name? Do
you have the proper user name and password setup?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm