PC Review


Reply
Thread Tools Rate Thread

Changing dbo in a ADP

 
 
jhmosow@gmail.com
Guest
Posts: n/a
 
      26th Jan 2006
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

 
Reply With Quote
 
 
 
 
aaron.kempf@gmail.com
Guest
Posts: n/a
 
      26th Jan 2006
make everything assigned to dbo unless you need to

via TSQL (you can make a sproc out of this for example)

you can run sp_changeobjectowner

if you ever need to find system stored procs like this; you can look
for them in master.dbo.sysobjects

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
NumberFormat not getting changing onFly changing the regional sett Dwipayan Das Microsoft Excel Programming 1 28th May 2010 07:55 PM
Changing row height in a data grid without changing font size =?Utf-8?B?S2FzZXk=?= Microsoft C# .NET 1 30th Jun 2006 12:20 AM
How to stop entire document style changing when changing 1 line? =?Utf-8?B?VHJveSBBLiBDb3VydG5leQ==?= Microsoft Word Document Management 4 1st May 2005 11:10 PM
Keeping Calendar times from changing when changing local time zone. George Lob Microsoft Outlook Discussion 1 22nd Nov 2004 05:14 PM
Difficulty in changing the Connection Server control path changing ... Samridhi Kumar Shukla Microsoft ASP .NET 1 30th Nov 2003 02:31 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:23 PM.