Re: Tables with no owner

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Big_Dumbass (big_dumbass_at_hotmail.com)
Date: 07/08/04 

Date: Wed, 7 Jul 2004 17:23:42 -0700

I will investigate the Access 2000 ADP aspect. My application is a C++ app
compiled with Borland C++ Builder. However, now that I am thinking about
it, this problem site has a third party application that accesses the
database. The third party application is written in visual basic which I
assume may have related ADP issues. The application, however, does not
modify the schema of the database. It may read, modify, or insert rows into
tables that already exist. Thanks for the responses.

"Russell Fields" <RussellFields@NoMailPlease.Com> wrote in message
news:ufwKR1FZEHA.3464@TK2MSFTNGP11.phx.gbl...
> Hello,
>
> I have seen this (personally) only with a database being administered /
> developed using Access 2000 ADPs. I really don't know _what_ is going on.
> For me, in all cases the following happened.
>
> 1. Tables without owners, where the uid was for a row in sysusers that did
> not exist.
> 2. Therefore, it never happens for tables owned by dbo.
> 3. The uid was always (again, for me) 1 higher than the maximum uid.
> 4. I created another user using sp_grantdbaccess. This user got the next
> uid and became the owner of the tables.
> 5. At this point, I could do whatever I wanted with the table.
>
> I would be interested if your scenario matched mine. If it does, then the
> answer may be to move development to Access 2002 / 2003.
>
> Russell Fields
>
> "Big_Dumbass" <big_dumbass@hotmail.com> wrote in message
> news:2l2qs7F7pe7bU1@uni-berlin.de...
> > Hello all,
> >
> > I have seen several occurences in my databases of tables existing with
no
> > valid owner. I have become quite adept at getting rid of these as they
> > hamper application functionality. My biggest question at this point is:
> > How can I prevent this from happening?
> >
> > I run the same application at multiple sites with structurally identical
> > databases and these tables keep popping up only at one location.
Needless
> > to say, it is becoming a maintenance nightmare to keep dropping these
> tables
> > that are getting stranded.
> >
> > Thanks for your help
> >
> > --
> > almost but not quite drastically
> >
> >
>
>

Relevant Pages

  • Re: ADP: Error calling SP with "EXEC sp_helprotect" statement
    ... By owner of the database, I simply mean an account such as sa that will ... I've tried your first piece of code yesterday both with ADP and QA and both ... Security and dbo. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL Database Diagram not showing up as an access object
    ... Maybe a problem with the schema (or owner for SQL-2000) used? ... database) from displaying as an access object in an ADP. ... The first database came across without a hitch and all the ...
    (microsoft.public.access.adp.sqlserver)
  • Re: ADP: Error calling SP with "EXEC sp_helprotect" statement
    ... before I don't know how to determine the owner of the database and the ... same applies to objects in the database. ... Security and dbo. ... I've got that right - we're both logging in to an Access ADP file as ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Table with no owner
    ... avoid updating system tables when possible. ... Looking in sysobjects revealed that there was uid with a non-NULL value. ... Add a user to the database. ... > I can't change the object owner without a current owner. ...
    (microsoft.public.sqlserver.security)
  • Re: Access 2003 to SQL Server 2000 over a VPN
    ... sufficiently fast response times, ADP may be a good enough client, ... Replication can be another solution, ... you're careful about your database design, though, that may be the way to ... As a result of the difficulties I've had, I try to avoid SQL Server ...
    (microsoft.public.access.adp.sqlserver)