Invalid Operation error?

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.
 
J

John Spencer (MVP)

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.
 
D

djc

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL server backend 2
query links to SQL server and mdb table 1
Invalid Argument - Append Query 1
Operation must use an updateable query 13
Problem with outer join - Invalid operation (Error 3219) !? 2
Runtime Error 3219: Invalid Operation 0
Query not working for SQL Server 2
error 3151 2

Top