When setting up or editing an ODBC external data source in FMP you're given three options for authentication:
• Prompt for user name & password
• Specify user name and password (applies to all users)
• Use Windows Authentication (Single Sign-On)
Out of caution I've been using only the first.
Question about the second: where/how does FMP store the user name & password entered? In the database? On the server computer? How secure is this option? It would be a great convenience to use, but security concerns prevail.