Re: Implied/hidden query in Data*** view?

Colin

You asked for pointers...

Access tables hold data, Access forms display it. I'd recommend that you
stop trying to use tables to display data.

--
Regards

Jeff Boyce
<Office/Access MVP>

"colin_e" <coline@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5B8F1A78-36F7-4149-8241-0882B7404CA7@xxxxxxxxxxxxxxxx
> I have a table "Org". Fairly straightforward, other than the fact that it
has
> a foreign key relationship to an "OrgType" table through the OrgTypeID
field.
>
> 1) When I open this table in data*** view (default), I receive a prompt
> for a
> parameter named "ID".
>
> a) It's not obvious to me how a TABLE (not a query) can have a
parameter??
> b) I have no objects or fields called "ID" anywhere in my database.
> c) Whatever I enter at the prompt makes no difference, I always see
the
> full
> table (as you would expect when opening a raw table)
>
> 2) In data*** view I cannot rename fields in this table, because Access
says
> the table is in use (locked). This happens after quitting/restarting
> Access or
> even a full reboot. However if I switch to design view I can rename
> fields.
>
> It looks to me as if Access is somehow running an "implied query" (if such
a
> thing exists) when data*** view is open, however I can find no
information
> in the help etc. as to exactly what is going on here.
>
> Any pointers would be much appreciated.
>
> Regards: Colin

.