I know nothing about Access, but how do you assign the ID values? If
it is done through a trigger, then it is impossible for Access - or
any other program at the client - to know the value. The only way is
to fetch the data from the server again. So, if you want to see data
instantly, your only option is to assign the ID value at the client,
not the server (e.g. through running a separate query getting the ID).

If you assign both ID and NAME manually as you say, then I have no
idea why things doesn't work.

HTH,
Set

--- In firebird-support@yahoogroups.com, 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