SQLT able into Access

[Peterg]

I have A SQL database with a Contacts table of about 2.9 million records.

I setup a project in access linking to the SQL database.

Of the 2.9 Milion records in the contacts table, i need to retrive the
customers with a activitycode of Convert Only in the table, .Maybe 300,000 to
400,000 Customers

Can Access handle this amount of records from a SQLTable.

I need to Upadte the information on the Converted customers and update it to
SQL database.

Tanks
Peter