Re: linked tables

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Wed, 22 Dec 2004 10:17:31 -0600

On Tue, 21 Dec 2004 11:08:24 -0500, "Jon Rizzo" <jrizzo at langan dot com> wrote:

¤
¤ Hello,
¤
¤ I am having a problem, and I was hoping that someone here could help me. I
¤ have an Access database define that contains two tables. There is a third
¤ table defined in the Access database which is linked to a SQL Server table.
¤ While I am in the Access environment, I can query between the linked and
¤ non-linked tables, but when I try to run a query that joins the linked &
¤ non-linked tables through ADO, it can't seem to access the linked table
¤ properly.
¤
¤ Can somebody explain to me how this is done in ADO?
¤

What do you mean by "can't seem to access the linked table properly"? Are you getting an error? A
prompt for a user name and password?

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

Relevant Pages

  • ~~~~~~~~~~~~~ MS ACCESS ~~~~~~~~~~~~~
    ... accdbman ms access database query table ... age bracket ms access report ... buy ms access download full version ...
    (comp.mail.pine)
  • Re: error messages when connecting to an MS Access query
    ... I'm actually opening the Word document from VBA in the Access database, ... It's actually easy to run a Make Table query in Access, ... I got messages saying it couldn't make the connection. ... When you try to make a DDE connection, if the database is not already ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Data connection not working properly in Server Explorer
    ... Apparently I have to use %Crystal when running it through ADO ... > I have a data connection to an access database, ... > When I run this query in Access it works fine, and I get back a list ... > View" it comes back empty. ...
    (microsoft.public.dotnet.framework.windowsforms.databinding)
  • RE: Using data from cells in a Query to a MS Access Database
    ... I tried what you had suggested and still could not edit the parameters. ... I then select "MS Access Database" and then browse to the location of my ... I did put in any filters because it won't allow me to enter in the cell ... "Microsoft Query" window and allowed to add criteria. ...
    (microsoft.public.excel.programming)
  • RE: ODBCDirect Workspace
    ... successfully ported my tables to SQL Server and have created an Access ... Are you using one Access database to work inside of another Access database? ... Dim strSql As String ... However if you are going to be using this query again to populate the combo ...
    (microsoft.public.access.modulesdaovba)