I have a DTS package that exports multiple tables to Access 97 using a data pump task per table.
The problem that I encounter, though, is that some steps fail with the following message :
"Unspecified Error - Could not update; Currently locked by user 'Admin' on machine <whichever desktop i'm running the DTS package on> "
I'm assuming that I need to amend the database locking mode properties from the advanced button that is part of the Access 97 connection to make sure that the database is not opened exclusively but I'm not sure what to put. This particular field isn't boolean.