Queries on Linked Tables

[droot]

Hi All,
I'm working on a project that accesses an MS Access DB. One of the requirements is to have a linked table in the DB that I can query from VB. I'm using a Data Environment Designer within VB 6 to do all of my queries to the DB. For some reason, it will not allow me to add parameters to the query to the linked tables, but automatically allows me to add them to non-linked tables. For example, here's a query:
Select * From PS_Header Where PS_Header.SSN = pSSN
where pSSN is a parameter to the query.
This works fine on regular tables, but does anyone know why I can't do this on a linked table?

 

[BobRodes]

I had some small experience with linked tables before, and I think it has something to do with the possibility that linked tables can be from a different syntactical environment, and therefore process parameters differently. Since you don't appear to be using a stored proc here, perhaps you can just fix up the string so that the parameter is hard coded in before you even hit the linked table?

HTH

Bob