Revision Date: 2008-01-28
Problem:
After installing SQCpack on a workstation or a server, users can create new databases and even create new groups. However, when trying to open any group for data entry, the group will open in read-only mode. This occurs with both customer data and the sample database.
Solution:
Ensure that the file DAO360.DLL is both present and registered on the system. The typical location for this file is:
C:\Program Files\Common Files\Microsoft Shared\DAO
The SQCpack installation program will only put this file on the disk if it is not already there. We have seen cases where the file is already on the disk - but is not registered.
Note that running PqAppInfo for MicrosoftJet4.0 will usually correct this problem.
Alternatively, the file can be manually registered using regsvr32.
Background:
When trying to open a group, SQCpack uses an OpenDatabase function within the DAO library as a way of detecting if another user already has the group open. This is one of the few places in the program where SQCpack uses DAO for database access as we typically use ADO database calls. Our install does not replace the DAO360.DLL file because the user's workstation may contain a newer version; possibly needed by some other application. However, if the existing file is newer and not registered, this situation can occur.
