I have a local database (access '10) with linked tables to a sharepoint (also '10). Every time I open the database it prompts me for a user name and a password to log in to sharepoint. How can I retrieve the user name that was entered? Application.currentwebuser doesn't work! I assume it is because the tables are just linked, and the database itself is not directly published on the sharepoint.
Please help, spent hours trying to find some references with absolutely no luck..... Thanks!!!