SQL 2000, Server 2003, Access XP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janet - 02 Jun 2004 16:47 GMT

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

Reply to this Message

janet - 03 Jun 2004 20:25 GMT

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

Wierd or what?

jb

>-----Original Message-----
>I had an Access XP connected through linked tables to an
[quoted text clipped - 10 lines]
>Janet
>.

Reply to this Message

Tony Toews - 06 Jun 2004 00:37 GMT

>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

Reply to this Message