I have a SQL 7.0 server. I have used DTS to import tables from Access to the SQL Server. Now, don't I have to link my tables in Access back to the SQL tables I've created? Hopefully this is not a stupid question, but how would I do this? What location do I look for from within Access? The .mdb file resides on the server itself.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Trying to link Access database to SQL server
- Thread starter elviajero
- Start date
You have already imported your access tables using DTS. So your tables now should be in SQL database.
Andel
andelbarroga@hotmail.com
Andel
andelbarroga@hotmail.com
Since your tables are now in SQL Server, what you need to do is create links to them within Access. Simply create an ODBC data source to the SQL Server Database, and use that data source as your ODBC name when you link the tables. I believe the ODBC data source option is the last one in the list to choose from in the Access "file types" drop down pick list, which opens up when you attempt to link to a table. Hope this helps.
- Status
Similar threads
- Locked
- Question
