Does it have anything to do with the data source being a parameter-query?
FYI: I am running Access 2010, but the file is saved using "Access 2002 - 2003 file format, if relevant.
For instance, we use the Security table and User table on many Access file. Normally, we just import those tables from another file.
However, if we need to update the information for those tables we have to update same information for users on each file many times.
The Link Table will eliminate the duplication of updating user information for this issue.
We just need to update the user information one time, for example User Login and Password, then the user can open many files with the same login ID and password.
So the business question is: "If we spend around USD100 on Excel 2013, will that save us USD100 of time or help us make a decision that improves our business outcomes by USD100, over the next 7 years?
I have an Access database containing a linked table that was created using Windows Authentication (I think).
However, I connect to it using a username and password instead.
Will I have to use .requery or such like, later on, when I will add code?
As for my previous post - I'm about to solve this issue by encapsulating PK's.