Linking SQL tables to Access - TechRepublic
Question
July 21, 2010 at 08:09 AM
valengrey

Linking SQL tables to Access

by valengrey . Updated 15 years, 11 months ago

Recently, the company I work for has switched to a different contrator that handles the historical database. The tables created by the old company used the standard dbo schema.Linking those tables to Access was a very simple matter. The tables that the new company created for us have a customized schema that Access does not seem to recognize. Can I simply change the schema of these tables to dbo? Is there a way to get Access to recognize other schemas? My supervisor suggested possibly creating a copy of the table,linking the original to the copy, changing the copy’s schema to dbo, and linking the copy to Access. Is this a viable option?

This discussion is locked

All Comments