B
bjv
I am facing a strange problem. I am trying to link tables
from a sql server 2000 database from an Access 97
database. When I chose the DSN, I get the error
message "Object invalid or no longer set". Once I click
on the error message, I can see only a partial list of
the tables (tables owned by only 2 users, none of the dbo
tables or other users' owned tables are displayed).
However when I do the same thing in Access 2000, there is
no problem at all with same DSN. Any ideas what could be
causing this problem ? Besides me, most other users are
also getting this error when trying to do same in Access
97. Thanks in advance.
from a sql server 2000 database from an Access 97
database. When I chose the DSN, I get the error
message "Object invalid or no longer set". Once I click
on the error message, I can see only a partial list of
the tables (tables owned by only 2 users, none of the dbo
tables or other users' owned tables are displayed).
However when I do the same thing in Access 2000, there is
no problem at all with same DSN. Any ideas what could be
causing this problem ? Besides me, most other users are
also getting this error when trying to do same in Access
97. Thanks in advance.