Linked SQL Server tables in MS Access

Expand Post »

I'm attempting to upgrade an Access database to use a SQL Server 2000 back end. I have installed SQL Server and created a DSN. However, when I attempt to link to the SQL Server database from Access (File/Get External Data/Link Tables/Select ODBC Databases) nothing happens! Any ideas what I'm doing wrong?

Thanks

Similar Threads

Access & MS SQL Server 2005 in MS SQL
MS Access v/s MS SQL Server 2000 in MySQL
Connecting to SQL server in Local machine in ASP
SQL Server Help in MySQL
Ms Sql Server 2000 in MS SQL

jimcooper

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS Access and FileMaker Pro Forum Timeline: LIKE doesn't work in Access

Next Thread in MS Access and FileMaker Pro Forum Timeline: Stumped: Error on Combo Box Sort

DaniWeb Message

Cancel Changes

User Name
Password