Issue Working Offline with Linked SQL Tables

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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
.

Relevant Pages

  • ADOConnection.DefaultDatabase error reporting behavior
    ... While connecting to the SQL Server if i give an offline database in the ... Source = Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.sqlserver.programming)
  • RE: web application development for Pocket PC
    ... while offline in SQL CE or an XML file on device. ... One more query We have sql server at the back end on ... Make a Compact Framework app using Windows ...
    (microsoft.public.pocketpc.developer)
  • Re: Cluster resource SQL Server (InstanceName) failed to come offline
    ... try taking the SQL Server resource offline and see the results/errors? ... resources in the SQL group offline, move the group to the other node and bring one resource online at a time -- starting with the resources that are not dependent on any resources i.e the disks first followed by sql ip ... Since AWE is enabled, max server memory is set to 7GB and passive node has 4GB, when you move the SQL Group to the passive node, SQL server instance will acquire almost all of the available memory ...
    (microsoft.public.sqlserver.clustering)
  • Re: 100 % CPU Usage
    ... Configuration is a 2003svr with sql server with sp4. ... > have taken 7 o 8 db's offline it goes away. ... which database you need to take off-line for the situation to resolve. ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: DIFFICULT PROBLEM! SSL for SQL 2000 Server. MS Fix bulletin does not help at all.
    ... Can you contact me offline? ... Your email address seems to be invalid. ... "Jason Robertson" wrote in message ... >> My only question at this time is, are you running SQL Server, ...
    (microsoft.public.sqlserver.fulltext)