Solved Migrate some tables, and keep the other ones locally

[Etxezarreta]

That is the same - a boolean field.
They are generally not very useful as data storage medium.
It's frequently better to store the date of the event rather than simply Yes or No.

e.g. InvoicePaid yes or no
or InvoicePaidDate 24/12/2020

Which is more useful?
You don't need both, as no date means not paid, and the date tells you both that it was paid and when.

Ok, I learnt something, thanks.

 

[Minty]

If you are populating a local table it may still be quicker to retrieve the data to populate it from a pass-through than via the linked tables as the query is run on the server and just returns a data set.

So move all your data gathering to the pass-through - run that as the source for your insert.

 

[Etxezarreta]

Allright then, I will try to create only one string gathering all the data, I haven't managed it so far.
Thank you very much for your time.
Etxe.

 

[Minty]

Don't forget you can store a query as a view on SQL server, so if you need to link a view to your pass through to simplify things you can easily do that.

SQL queries are much easier to write in SSMS than in Access once you get your head around things.

 

[Etxezarreta]

This is very encouraging, thank you very much, and have a good day.
I will try later, and will mark this discussion as "solved" if the process is successful.
Etxe.