General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2008 Server
>If you are getting into the code where the table is opened exclusively you already have an exclusive lock it can't be a sharing problem.
>
>So that rules out issues related to locking/contention.
>
>If this is intermittent then this is some sort of OS file system or permissions issue.
>
>I would suspect Anti-Virus as others have. This is the most common problem for intermittent file operation failures on writes especially.
>
>Another thing to think about: Where do the files live? Are they in AppData or a User folder? If not and Windows UAC is on Windows will move those file under you to a private user store. So if the files live in the programs folder and permissions have not been set explicitly for that user the files are virtualized and can be moved under you - possible that only manifests intermittently as a file is moved while writing to it. Easiest way to check for this is to run the app as Run As Administrator or explicitly give full permissions to the user running the app...
>
>+++ Rick ---
Thanks, Rick. Some good ideas there.
Tamar
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only