Recently had some weird behaviour in Access 2007 SP1 on Windows XP SP2.
Application with odbc linked tables ( SQL SERVER 2005). If I'm showing an
updatable query , linked to a table with an primary key by odbc
connection,
and i don't include the primary key field, I cannot add a record! I am
able
to do workaround with a saved query though: add th PK , but hide the field
in
the query ( I have no need to whoe the PK field).
With a link to an Access database this problem doese not exist.
Is this a possible bug , or default behaveour?
btw, I saw this was also the case in access 2003, so appearently its not
something exclusively for access 2007 .
Thanks
Alain Bobbe
BM Systems
|
