Answer for:

MS Access ODBC on Windows 7

Message 3 of 5

View entire thread
0 Votes

Very useful suggestion! the non-admin user can create a User DSN and when they Test Connection -> "Test Successful"!
However in MS Access, when creating the ODBC linkage it returns with "ODBC--call failed". Not very informative eh?
I suppose that now we know it is an MS-Access specific issue - should I re-post elsewhere as an MS-Access query?