I have done this with linked tables.  What I have found is that you SHOULD NOT just link the tables to a form and let the user scroll from row to row. 

You should only allow a form to link to one row at a time.  In the apps that I created (about 5 years ago!) I always had a form that allowed the user to choose the row and then filter the form.  That way you are not locking up rows and you are not pulling the whole table from SQL Server.