Very Computer

Try this :

Create 2 tables.
Create a trigger (on insert) in the first one to insert a record in the
other one.

Like this one :
Create trigger Test
On dbo.Table1
For  Insert
As
set nocount on
insert into
dbo.Table2(id)
select 1
 return

Open in access the first table and insert a record. You have an error
message saying that the record not correspnding to the current filter and
will not be display.

The problem don't appear with ODBC or ADO with Borland DELPHI 5.

Access make me crazzy !

I think the problem should occur with any kind of client.

Since the insert trigger inserts data in another table (I guess table2 has

A2K->ADO->ODBC uses

after inserting a new record in order to retrieve the key of the inserted

got the error message.

including mine.

Quote:> Try this :

> Create 2 tables.
> Create a trigger (on insert) in the first one to insert a record in the
> other one.

> Like this one :
> Create trigger Test
> On dbo.Table1
> For  Insert
> As
> set nocount on
> insert into
> dbo.Table2(id)
> select 1
>  return

> Open in access the first table and insert a record. You have an error
> message saying that the record not correspnding to the current filter and
> will not be display.

> The problem don't appear with ODBC or ADO with Borland DELPHI 5.

> Access make me crazzy !

Thanks a lot and when i delete a record via storeproc Access hide it but if
I try to edit the record withch take his place it make an error as if he
keep the position of the delete one.

I hope you understand me (I m french)

Hi Polaire,

this is a known bug (we had had the same bad experiences with SQL and A2K)
Get the latest OfficeUpdate on

http://officeupdate.microsoft.com

maybe that will fix your problems (We cant use the bugfix because of a
different language)

best regards,
Uwe Ricken
MCP FOR MS ACCESS DEVELOPMENT
GNS GmbH, Frankfurt am Main

Quote:>Try this :

>Create 2 tables.
>Create a trigger (on insert) in the first one to insert a record in the
>other one.

>Like this one :
>Create trigger Test
>On dbo.Table1
>For  Insert
>As
>set nocount on
>insert into
>dbo.Table2(id)
>select 1
> return

>Open in access the first table and insert a record. You have an error
>message saying that the record not correspnding to the current filter and
>will not be display.

>The problem don't appear with ODBC or ADO with Borland DELPHI 5.

>Access make me crazzy !