Re: Implied/hidden query in DataSheet view?

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

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 datasheet 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 datasheet 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 datasheet 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

.

Relevant Pages

  • Re: Seeting malloc pointer to NULL [2] -Totally confused!!!!!
    ... Best regards ... So now that I have gotten it to work in the VC++ compiler, ... mayby my compiler doesn't support pointers to pointers! ... from void* to other pointer types. ...
    (microsoft.public.vc.language)
  • Re: For each ..... next Question
    ... thanks for those pointers on my existing code. ... Regards ... > This sample will list all the powerpoint files in my documents. ... >> Michael Bond ...
    (microsoft.public.dotnet.languages.vb)
  • Re: For each ..... next Question
    ... > thanks for those pointers on my existing code. ... >> This sample will list all the powerpoint files in my documents. ... >>> Regards ... >>> Michael Bond ...
    (microsoft.public.dotnet.languages.vb)
  • A big thank you
    ... check out the new posts and to pick up pointers from other peoples ... Regards ... Seamus ...
    (microsoft.public.excel.programming)
  • Re: wiki package recommendation
    ... > can anyone recommend a wiki package and willing share their ... > any pointers will be appreciated. ...
    (Debian-User)