How can I make my views faster from Access to SQL Server? I have a 6 tables each with a "Select *" view. That way the Access programs do not have update capability on the original tables. Note: I have created the views with the same name as the original tables, deleted the old tables and relinked the views. The original tables are much faster than going through the views.