I have been successful in creating and ODBC link between an Access database and DACEasy data. I want to implement this connection for several users excpt there is one issue.
When running a query that involves these tables linked to DACEasy, we get a Username and Password prompt. Regular users do not work, only Admin level users work. Is there a way I can pre-specify or auto-logon with this? Or create a user that cannot logon to DACEasy but has the rights to link to these tables?
It's runnng a Pervasive 9 engine.