Hi
I have a msaccess table acctbl and linked table from Oracle oratbl. I am running an update statement on acctbl and access is not responding and finally I have to cancel it out
Records in tables are :
oratbl - 6469806
acctbl - 3542
Update Statement
UPDATE acctbl INNER JOIN oratbl ON acctbl.BookID = oratbl.Book_ID SET acctbl.Book_Price = oratbl.Book_Price;
Can some one let me know how can we correct it.
Thanks,
Sun