I can see an ODBC connection available (default name WINFAS32) but can't connect to it. I'd like to automate some spreadsheets that can verify VIN#s on our insurance policies. I've tried integrated security and specified user names, but neither seems to work. I get an ODBC error that the name and password are invalid. It does seem to be seeing the file okay, because if I have it open it gives me an error that it in use (single user version).
Has anyone else been able to communicate with the ODBC connector?