Hello,

I have a query which joins two tables using a field which is indexed on 

both tables, and updates all the records on one table using values from 

the other. Pretty straight forward I thought.  It runs fine on Access 

1997, takes a minute to update 100 thousand rows.



On Access 2000 it hangs up, what's the deal?  The Access 2000 engine is 

the default Jet engine.  Do I need to use DSDE?  How many records can 

Access 2000 using Jet handle in an update?



I'm just in the process of converting to 2000, and this is a problemo.



The query is:



UPDATE Ordr_Import INNER JOIN Temp_Dates_Ordr 

ON Ordr_Import.DUE_DTE = Temp_Dates_Ordr.Temp_Date 

SET Ordr_Import.Yr = Temp_Dates_Ordr.Yr, Ordr_Import.Mth_Text = 

Temp_Dates_Ordr.Mth_Text;



Thanks.

By "hangs up" do you mean that it goes away and never comes back, or does 

it give you some kind of error message?  I've had a problem before with 

trying to do certain functions on a database on the LAN that caused it to 

go away and not come back. Does that sound familiar?

... AL