Recent content by RosscoP

Thanks it's much appreciated. And the same to all who helped out!

This has done the trick! Can you advise the difference between the use of 'ALL'?

How do I limit a linked table? Or do I need to create two select queries which I will then apply the union to?

I'm sure it's not the same but bear in mind both the tables I'm combining are in the same database that is about 998MB in size. I'll give the limit a go.

Is this to ensure that the issue is down to volume rather than an issue with the query itself?

Hi All, Thanks for the responses. The query is rather simple: select * from Table1 union select * from Table2 The query will present something like 2.4 million rows. I did a compact and repair but typically the database is no more than 600KB as both tables are linked.

I tried with the linked query but I got the same error.

That was my thinking. The database I am linking to is under 1GB so it seems odd that I'd hit a limit but I think it might be memory related? I'll try your suggestion and see how it goes. Thanks!

I have a database that is used to create a data file for a customer. The database has two linked tables that are linked to tables that are both in another database (but within the same database as each other). Their structure is identical. I have a union query set up to combine both linked...