This is more about opinions rather than a specific question.
When I happen to decide to view data in another Access file, I sometimes use and have recommended to others the following syntax:
Yesterday while searching the web on an unrelated topic, after I was finished, decided to click on some of the other articles (such as this one) https://www.databasejournal.com/fea....php/3647466/Queries-On-Steroids--Part-II.htm and came upon a different syntax to achieve the same result:
Seems like it might be better when constructing it as a query string since it doesn't use quote marks and there is no confusion about IN which is also used in queries for criteria instead of OR. Other than that are they functionally equivalent or is the original method preferred as that is how Access constructs it if using the graphical interface?
When I happen to decide to view data in another Access file, I sometimes use and have recommended to others the following syntax:
Code:
SELECT *
FROM tblTableName IN 'C:\Users\Documents\AccessFiles\AnotherFile.accdb';
Yesterday while searching the web on an unrelated topic, after I was finished, decided to click on some of the other articles (such as this one) https://www.databasejournal.com/fea....php/3647466/Queries-On-Steroids--Part-II.htm and came upon a different syntax to achieve the same result:
Code:
SELECT *
FROM [C:\Users\Documents\AccessFiles\AnotherFile.accdb].tblTableName;
Seems like it might be better when constructing it as a query string since it doesn't use quote marks and there is no confusion about IN which is also used in queries for criteria instead of OR. Other than that are they functionally equivalent or is the original method preferred as that is how Access constructs it if using the graphical interface?