Linking SQL tables to Access

By valengrey ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Here is the Solution

by valengrey In reply to Linking SQL tables to Acc ...

None of the stuff I mentioned in my initial question were necessary. By default, the User Data Source was pointing to the old database that the previous contrator had set up. Here are the steps I took to resolve the issue:
1. Go to Administrative Tools
2. Click on "Data Sources(ODBC)" icon.
3. On the "ODBC Data Source Administrator" window, click ADD.
4. Select the SQL Server driver from the list of options and click FINISH.
5. The "Create a New Data Source to SQL Server" window pops up. Fill in requested info.
6. The "Microsoft SQL Sever DNS Configuration" window pops up. Configure it how you want. Click NEXT.
7. Click the box by "Change the default database to" and select the database you want. Click NEXT. Click FINISH.

Rock On!!

Related Discussions

Related Forums