Well, when IMAGE does a "Now you see it, now you don't", often the cause is
ITEM or SET level security.  Depending upon which password is used to access
the database items and sets seem to appear and disappear.  Only when logged on
as created and supplying ';' password can you be sure to 'see all'.

When you say 'DBG said they were already there...', I assume we are talking
about QUERY opening the base with a password which does not see the items and
DBG opening with a password that does, possibly the 'see all' situation.

The issue might be when the items were added a WRITE/READ access class was not
applied to the items which should have been?  The fix might be to update the
item security to match other items. 

The test would be to access the base as creator and use the ';' password.  If
the items are then seen, we assume item level security is the issue.

Removing the entries and then adding with accessible security would correct
the
problem.  Easier might be to change the security of the items.

tj

P.S. Both products are correct, just from different security access rights !




At 07:37 AM 8/28/98, Roy Brown wrote:
>We supplied an upgrade to a client which involved adding an extra data
>element to an Image database, and to two of the sets on it.
>
>When diagnosing problems (unrelated to these entries), we reviewed this
>database in Query, and happened to notice that the new entries did not
>appear.
>
>Accordingly, we tried to add them in DBGeneral, the client's choice of
>DB Manager. However, DBG said they were already there, so it couldn't
>add them.
>
>We confirmed that we were looking at the same database in both cases,
>and it wasn't some file equate weirdosity. Not was it a 'pending change'
>situation in DBG.
>
>In the end, we had to tell DBG that it should remove the entries, which
>it was quite happy to do, and add them again, which it was again happy
>to do. After which they were visible in Query.
>
>Wha' happen? Which product was right?
>--
>Roy Brown               Phone : (01684) 291710     Fax : (01684) 291712
>Affirm Ltd              Email : [log in to unmask]
>The Great Barn, Mill St 'Have nothing on your systems that you do not
>TEWKESBURY GL20 5SB (UK) know to be useful, or believe to be beautiful.'
> 



   Tim Joseph
   425-485-8536 (phone)
   [log in to unmask] (email)
   425-485-7801 (fax)
   http://www.bradmark.com/