Re: linked tables

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 12/23/04 

Date: Thu, 23 Dec 2004 10:40:24 -0600

On Wed, 22 Dec 2004 15:37:18 -0500, "Jon Rizzo" <jrizzo at langan dot com> wrote:

¤ Yes, when I try to access the linked table, I get this error message:
¤
¤ Error Type:
¤ Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
¤ [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'MyDatabase'
¤ failed.
¤
¤
¤ If I import the same table rather than linking it, the code works fine.
¤ What do I need to do in order to access this linked table?
¤
¤ Jon

I don't know whether your SQL Server database requires a user ID and password for access, but if so
you will probably need to specify this information in the linked table connection.

Access will cache this information but other applications that open the database will know nothing
about it.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Relevant Pages

  • Re: Reviewing my code. Displaying a BLOB image through a browser
    ... Ok I made that change and now I get this error message in my browser. ... Microsoft OLE DB Provider for ODBC Drivers ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • VSS Errors using NTBackup
    ... Microsoft OLE DB Provider for SQL Server ... Error message: ...
    (microsoft.public.windows.server.sbs)
  • Re: Opening Word multiple time with linked text file
    ... >stored in a SQL Server database that changes earch time the report is run. ... >I get the following error message. ... >The Microsoft Jet database engine cannot open the file 'tmpLegal.txt'. ...
    (microsoft.public.access.externaldata)
  • Re: ASP prob.
    ... search for the error message. ... (Reverse address to reply.) ... "Tony Schlak" wrote in message ... > Microsoft OLE DB Provider for ODBC Drivers error '80004005' ...
    (microsoft.public.inetserver.asp.db)
  • Re: Write conflict
    ... If this is a SQL Server database and you have a Bit field in your table, ... Roger dot Carlson at Spectrum-Health dot Org ... > I get the following error message when i do an edit on a database i am ... > Copy to clipboard or Drop Changes (The save record option is greyed out) ...
    (microsoft.public.access.forms)
Loading