Issue Working Offline with Linked SQL Tables

Issue Working Offline with Linked SQL Tables

Post by TWVsbGlzc2 » Thu, 09 Apr 2009 22:39:03


I have a small Access 2003 database with local tables and a few linked tables
to SQL Server. I want to be able to work on the application offline, but
everytime I open Access (not try to use the linked tables) I recieve the
following error:

Microsoft SQL Server Login
Connection failed:
SQLStat: '01000'
SQL Server Error: 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 6
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server
not found.

Isn't there a way to work offline with linked SQL tables?

Any help would be appreciated. I've searched all of MSDN and cannot find
how to set up an offline work arrangement with SQL tables.




--
MIS Analyst/Programmer
US Bank
 
 
 

Issue Working Offline with Linked SQL Tables

Post by SmFtaW » Fri, 05 Jun 2009 13:11:01

If there isn't a lot of data in the tables you can Import the tables from SQL
Server.
Or you could put in some code to dettach the linked tables which will allow
you to work on local tables and not worry about the database connectivity
issue.