INSERT INTO DATABASE_LOGIN_FILE ( , [TIME], [DATE], [DATABASE], COMPUTER, NOTES )

SELECT Environ("USERNAME") AS , Time() AS [TIME], Date() AS [DATE], "Refresh HD-Stat" AS [DATABASE], Environ("COMPUTERNAME") AS COMPUTER, "LOGIN" AS NOTES;That query appears to be saving the details of the user, computer, in a table called 'Database_Login_File" which may or may not be a linked SQL Server table. As such it should appear as an Append Query in the Navigation Pane. If you want to see what queries are being used to append SQL data into local tables, sort the queries by type in the Nav Pane, and then look through queries that append to local tables - you will have to open each and check the properties - from linked SQL Server tables.

I agree with J Livingston SQL that it's quite unusual to see an apparently sophisticated database using macros that way, although the macro capability was enhanced significantly in Access 2010. Is it possible that a portion of the data is being upsized to a web or SharePoint app? The fact that there are many databases that apparently connecting to the same database for reporting purposes also is a concern. We typically put all the reports into a single database and then distribute the same front-end to all users, limiting who can see what reports with the menu and security. Otherwise you have a change control nightmare as soon as tables are modified or added.

Sorting through such a situation is essentially a long and tedious process - I've done it a number of times in the past 20 years, and it just takes time and research.