As a rule 99% of the time you should never use linked tables from Access to SQL.  It's just a very good way to snarl up your SQL server.

I always advise using Access projects instead, they give you the easy forms and macros, but with SQL as the backend (rather than Jet accessing SQL)