I have a DTS package that deletes data from a table and then re-populates the
table with fresh data from our ERP system. The problem is this particular
table is linked to an access database, and if a user has the table open in
access the DTS package will not delete the data, it does not error out, but
waits until the user either closes the table or scrolls to the last record,
then it will run as expected. There are no problems if the user is using
access query to get the data. I would like to have this package run
several times a day and not have to worry about failure if the user opens the
table, is there anyway to take ownership and delete the records in the table
and re-popluate and release the ownership?

PS I have 4 tables that are reacting this way and 2 tables that there are
not any issues with. All of the tables are contained with in the same SQL
Database.

Hi Larry,

Thanks for inquerying.

Please understand the problem you described is by design. Because if one
user took ownership of the table, we cannot make sure whether he is
Inserting, updating or deleteing any records. In such scenario, if we are
able to modify the records, the results of the operation by the first user
will be incorrect. That's why the table will be locked. Actually, as you
said, there are no error and the package just waited other users to close
the table. I think this is the only workaround.

I'm sorry for any inconvenience. Thanks.


Best regards,

Vincent Xu
Microsoft Online Partner Support

================================================== ====
Get Secure! - www.microsoft.com/security
================================================== ====
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties,and confers no rights.
================================================== ====



--------------------