Updating a large table

This really isn't a large table by Access standards, as it has only about 1 million records, but nevertheless it's taking a long time to run the update query. Here's the query:



UPDATE [Db] INNER JOIN [Small Table] ON [Large Table].text1=[Small Table].[text1] SET [Large Table].[text2] = [Small Table].[text2];



[Large Table] has about 1 million records and [Small Table] has 10 records.



Can someone please suggest a query that will run quicker?



Thanks.

Updating a large table