Ownership changed to "engine"

[Guest]

I inherited a poorly implemented database, but I wont bore you with the
details. No security is implemented.
The database is on a server and used by multiple users (sometimes
concurrently)
Recently opened the database and some tables and queries appeared to be
missing.
I set hidden objects to be shown.
The missing objects appeared grayed out.
Looking at the properties, the owner is "engine", and the create and last
update dates are some time in 1996. Some were created in 2003, and some were
added within the last month.
I can open and view the objects, but I cannot change owership or delete them.
This is true regardless of whose computer I use.
How could this happen, how can I correct it, and how can I prevent it in the
future?

 

[Rick B]

To correct, you would need to create a new database and import all the
objects to it. I always do this when I inherit a database any way.

Rick B

 

[TC]

Klatuu wrote:

(snip)

The database is on a server and used by
multiple users (sometimes concurrently)

Then it should be split into a so-called "front end/back end"
structure. Google on FE/BE, split database, or similar for more
information.

HTH,
TC

 

[Guest]

Thanks, TC, but I know how it SHOULD be done, remember, I inherited this mess
and am trying to clean it up and implement it correctly. You would not
believe some of the goofy things they have done here. For example, we do a
monthly import from another sector and the routine is they import a table
that has to be broken down to multiple tables. Rather than a VB routine to
edit and apply the data, they use over 1oo queries, many of which have to be
modified each month and still have to go in and hand clean the data. They
would be better off with a pencil and paper.

 

[TC]

Gak! Good luck cleaning it all up

TC