Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BadBoy House
Starting Member
41 Posts |
 Posted - 2011-09-23 : 04:00:28
|
| We've got a business management system which holds all of our client data - names, addresses etc etc. The data is all held in an SQL db.We carry out mail merges using an MS Word link to a data source - an Access database. The Access database in turn links to a View on the SQL database.The problem we have is that intermittently, when carrying out an MS Word Merge, one of the tables on the SQL database (a table from which the Access database pulls data from) becomes locked and this prevents any changes from being made to the table in SQL back in the business management software.Clearly the MS Access database link to the SQL view is somehow locking one of the corresponding tables.Is there any reason for this? |
|
|
|
|
|
Access Mail Merge DB keeps locking our SQL DB