Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock Vioations

Status
Not open for further replies.
trudye10

trudye10

Programmer
Sep 8, 2006
67
Heey Guys, I am having a problem with Lock Violations in a query. I am accessing files that reside on an SQL Server. I ran an Update query that produced the error. Is there anything I can do to get around this error.

Thanx,
Trudye
 
Sort by date Sort by votes
I solved the problem, well I didn't really solve it, it just kinda went away. But Microsoft says you have to insure Field Prop: Required = No, and Allow Zero length = Yes.

Thanx,
Trudye
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mmogul
  • Locked
  • Question
File Share Lock Count Exceeded - Only Occurs when table on back end
Replies
1
Views
40
genomon
genomon
merlizbet
  • Locked
  • Question
error 3188: "Could not update; currently locked by another session on this machine"
Replies
1
Views
95
merlizbet
merlizbet
merlizbet
  • Locked
  • Question
import spreadsheet issue from form button = table locked
Replies
4
Views
78
merlizbet
merlizbet
jeffwest21
  • Locked
  • Question
Database locking
Replies
10
Views
69
PHV
PHV
StrikeEagleII
  • Locked
  • Question
Difference between ADO recordset "update criteria" and "lock type
Replies
0
Views
66
StrikeEagleII
StrikeEagleII

Part and Inventory Search

Sponsor

Back
Top