Invalid Operation error?

  • Thread starter Thread starter djc
  • Start date Start date
D

djc

recently all tables were moved from an access mdb file backend into sql
server 2000. The access 2002 front end file links via ODBC connection to sql
server tables now. We came accross a query that is giving an 'Invalid
Operation' error. This query contains 2 other queries that are joined. This
worked fine when backend was in access. The only change is that now the
tables are jet-connected ODBC tables.

Is there a known issue with this kind of query?

any info is appreciated.
 
One thing to check.

SQL is more sensitive about the joining fields. IF you are joining on text
fields, make sure that the fields are defined the same including the allowable
field lengths.
 
will do. Thanks.

John Spencer (MVP) said:
One thing to check.

SQL is more sensitive about the joining fields. IF you are joining on text
fields, make sure that the fields are defined the same including the allowable
field lengths.
Click to expand...
 
Back
Top