Hi!
I have an Access 2003 application with some tables linked from SQL Server 2005. Recently, it has started prompting for Data Source on open. Does anybody have a clue why?
Hi!
I have an Access 2003 application with some tables linked from SQL Server 2005. Recently, it has started prompting for Data Source on open. Does anybody have a clue why?
After looking some more, I discovered that this happens when the following query is run:
"SELECT SYSTEM_USER AS <name>"
How do I set a permanent odbc data source for this?