Linked Table issue

[Skip Bisconer]

I want to link tables from another Access data base but when I build a query and save and then run it I get the attached error. It also won't allow me to delete the link or close the data base once the error pops up.

Any suggestions? I have copy/pasted the name of the table, AP Vendor Master, and I can't see anything wrong with the name. It opens like it should in table view. I don't understand the error. It happens with every table I have tried to link.

 

[pbaldy]

What's the SQL of the query? Offhand I don't like the spaces in the name, though if properly bracketed it should still work.

I was in your area the other day. Visited my daughter and her husband at his parent's place in Redding.

 

[Skip Bisconer]

I had to dump the database so I could try again. I couldn't open the query in SQL (it was disabled) to see what was going on. I couldn't open it in design view either. I am trying it again and will get back to you.

Did you get a chance to see how low Shasta was. We went up to Washington just before Christmas and I have never seen it so low.

 

[Skip Bisconer]

This time the query would open in Datasheet view but if I opened in SQL view and then tried to go to Design view I get the error. I can't get to design view right click the query either.
SELECT [IN Whse Qty Invoiced History].INWH_PART AS Part, [IN Part Master].INPM_DESC, [IN Whse Qty Invoiced History].INWH_BIID AS WHse, Round(([IN Whse Qty Invoiced History]![INWH_BI18]+[IN Whse Qty Invoiced History]![INWH_BI17]+[IN Whse Qty Invoiced History]![INWH_BI19]+[IN Whse Qty Invoiced History]![INWH_BI20]+[IN Whse Qty Invoiced History]![INWH_BI21]+[IN Whse Qty Invoiced History]![INWH_BI22]+[IN Whse Qty Invoiced History]![INWH_BI23]+[IN Whse Qty Invoiced History]![INWH_BI24])/8,0) AS Avg_MoP1, [IN Part Master].INPM_MRPR, [IN Part Master].INPM_MPPC, [IN Whse Quantities].INPM_BQOH, [IN Whse Quantities].INPM_BQMN, [IN Whse Quantities].INPM_BQMX
FROM ([IN Part Master] INNER JOIN [IN Whse Qty Invoiced History] ON [IN Part Master].INPM_PART=[IN Whse Qty Invoiced History].INWH_PART) INNER JOIN [IN Whse Quantities] ON [IN Whse Qty Invoiced History].INWH_PART=[IN Whse Quantities].INPM_PART
WHERE ((([IN Whse Qty Invoiced History].INWH_PART) Not Like "-*" Or ([IN Whse Qty Invoiced History].INWH_PART) Like "/*") AND (([IN Whse Qty Invoiced History].INWH_BIID)="1") AND (([IN Whse Quantities].INPM_BWID)="1") AND (([IN Part Master].INPM_PCLS)>"199" And ([IN Part Master].INPM_PCLS)<"965"))
ORDER BY [IN Whse Qty Invoiced History].INWH_PART;

 

[pbaldy]

I didn't see Shasta; I came over the hill directly into Redding, so never went past it. We're getting snowed on as I type, so hopefully all the lakes will fill back up. I'm sure Shasta, like Tahoe, holds a lot of water, so it's probably hard to refill once it gets down. We need a good winter.

If you do a simple "SELECT * FROM LinkedTableName", do you get the same error? I'm trying to narrow down the cause. I don't suppose you can post the databases?

 

[Skip Bisconer]

I'll try and whittle it down and post it.

 

[Skip Bisconer]

I can't get the database down small enough to post.

I thought I was able to make a separate query for the records I need from each linked table then combine the queries But that didn't work either.
I am going to try and create make table queries on the linked tables and see how that works. I don't know how this would work in real time.

If I try and remove one of the linked tables from the database it gives me the error message and will not delete the table.

I made Make Table queries and tried to work directly off the tables but that didn't work either. Now I will try importing the table into the database and see what happens.