J
jhmosow
I have an Access 2003 ADP that connects to a Microsoft 2000 SQL Server.
I changed the owner of some of the tables/views/functions in the SQL
database but when I attempt to access these tables, the ADP can not
access them, looking for the table with the old owner in the qualified
name.
It is very strange since even some of the ADODB queries I use, with the
fully qualified table name is still trying to access the table with the
old owner.
I can not see how to change the ADP to recognize to new owner on
tables/views/functions.
Any assistance is greatly appreciated.
TIA
I changed the owner of some of the tables/views/functions in the SQL
database but when I attempt to access these tables, the ADP can not
access them, looking for the table with the old owner in the qualified
name.
It is very strange since even some of the ADODB queries I use, with the
fully qualified table name is still trying to access the table with the
old owner.
I can not see how to change the ADP to recognize to new owner on
tables/views/functions.
Any assistance is greatly appreciated.
TIA