This is normal behavior, outlined in your Access documentation.

Jason


Adomas Urbanavicius wrote:

> Hello,
> Linked MS Access via odbc to FB table.
> Deletion and editing : OK.
> But after inserting record, in field places we see strange values :
> "#Deleted".
> After closing, reopening table/form : values are correct. But while
> browsing table, after insertion, in new inserted records in all places
> shown values look "#Deleted".
>
> Anyone faced this issue ?
>
>
> Sample :
> ID ,Name
> 1 Name1
> 2 Name2
> 3 Name3
>
> Inserting (manually) records :
> 4, Name4
> 5, Name5 .
>
> While browsing table we see :
> 1 Name1
> 2 Name2
> 3 Name3
> #Deleted #Deleted
> #Deleted #Deleted
>
> After reopening table :
> 1 Name1
> 2 Name2
> 3 Name3
> 4 Name4
> 5 Name5
>
> How to make records instantly to look ok ?
>
>
>
> Adomas
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>

--
The information transmitted herewith is sensitive information intended only for use to the individual or entity to which it is addressed. If the reader of this message is not the intended recipient, you are hereby notified that any review, retransmission, dissemination, distribution, copying or other use of, or taking of any action in reliance upon, this information is strictly prohibited. If you have received this communication in error, please contact the sender and delete the material from your computer.