By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,611 Members | 1,399 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,611 IT Pros & Developers. It's quick & easy.

Error 3167 record deleted

P: n/a
HI,
i have an access MDB linked by ODBC to SQL2k.

I get a strange behaviour when i do an INSERT INTO to a local Mdb table
from "LEFT OUTER JOINED" SQL tables.

If the related table hasn't related record to the first table,
it get an Error 3167.
This behaviour is not present with MDB tables JOINS.

Who know something about this ?

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
merco wrote:
HI,
i have an access MDB linked by ODBC to SQL2k.

I get a strange behaviour when i do an INSERT INTO to a local Mdb table
from "LEFT OUTER JOINED" SQL tables.

If the related table hasn't related record to the first table,
it get an Error 3167.
This behaviour is not present with MDB tables JOINS.

Who know something about this ?


AFAIK Access will populate both tables in a single update, but SQL
Server does not allow this.

One possible way around it is to use a view on the server and write an
"instead of" trigger for it.

e.g. (air code)
create view view1 as
select table1.col1 as col1, table2.col2 as col2 from table1 inner join
table2 on table1.col1=table2.col1;

create trigger iTrig_view1 instead of insert as
insert into table1 (col1) select col1 from inserted
insert into table2 (col1,col2) select col1,col2 from inserted
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.