This is a strange one but I am hopeful someone will have the answer.
When I export table data to an Access database via DTS (ODBC) all works well when ran from local user account. However, when ran from service account SQL locks the Access Database.
The service account has rights to the local share, the database (well access security is ....) has the oppropriate rights.
Why is the service account locking the access database? And what if any is the solution here. Yes I know I would love to move it to SQL all together but the client requires the data in an Access database.
Basic concept.
Import text data to SQL table.
ODBC to Access database clears the existing table. (keeping the table format)
Exports data from SQL table (generated from txt file)to MS Access database.
Thinking through things I am not so sure this is an authentication or security issue but rather a Data Pump or ODBC connect/disconnect issue.
Thanks in Advance,
When I export table data to an Access database via DTS (ODBC) all works well when ran from local user account. However, when ran from service account SQL locks the Access Database.
The service account has rights to the local share, the database (well access security is ....) has the oppropriate rights.
Why is the service account locking the access database? And what if any is the solution here. Yes I know I would love to move it to SQL all together but the client requires the data in an Access database.
Basic concept.
Import text data to SQL table.
ODBC to Access database clears the existing table. (keeping the table format)
Exports data from SQL table (generated from txt file)to MS Access database.
Thinking through things I am not so sure this is an authentication or security issue but rather a Data Pump or ODBC connect/disconnect issue.
Thanks in Advance,