I am experiencing an interesting problem with the QODBC certificate that goes into the integrated applications section of QB.
I have an accounting server that several people can remotly log onto with their unique user name and password. Each user has the QODBC driver setup on their profile so that when they are logged in, they can run an MS Access database which pulls from tables within our QB file.
In the recent past, it didn't matter who was logged in and running the database, it always pulled data through the QODBC driver without QB being open
Now, we are having problems in that every user has to re-establish the certificate by logging on as admin and waiting for the integrated application prompt for that certificate. Once the certificate is established for that user it works fine for that user. If they log off, and another person logs on, the new user will have to establish a certificate again for themselves, which makes it so that the other users certificate is broken.
The only difference between the time when it was working and now is that one user has the read write version of QODBC and another user has the read only version of QODBC: They are both version QODBC 7.00.00.214.
Does any one know of solution to this? |