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?
