DLookup to another database (1 Viewer)

We have a SQL Server back-end and about 30 Access front-end applications. We use one library file to handle common functions which is included in each of the front-end applications.

A problem I have is, sometimes in a library function I would like to make use of a DLookup which examines one of the tables, e.g. However when one of the front-end applications (e.g. Projects.accde) makes use of this function, it will try to find a the tblDocuments table within itself, not the library. I can fix the problem by ensuring the same table is linked to our SQL Server within the Projects.accde application, however this would be tiresome to check across all our applications, and I'm looking for something a bit more robust where the success of the function is not reliant on the Projects.accde application having that table.

Something along these lines perhaps (this doesn't work!):

There's no way of doing this but you can query a table in another database using a DSN connection and SQL query.
If you built a function to do this you could this you could simply call the function instead of your Dlookup...