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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Record Locking Not Working from ODBC

Status
Not open for further replies.
briangriffin

briangriffin

Programmer
Nov 6, 2008
878
US

From the MSDN record locking article:

"Data in a form, report, or query from an Open Database Connectivity (ODBC) database is treated as if the No Locks setting were chosen, regardless of the RecordLocks property setting."

This is what is occurring for me - no locking seems to take place regardless of the Access locking settings.

I have a form that retrieves one record at a time for users to edit. When they click the next record button I need them to go to the next record that is not currently open by another user.

Surely there is a workaround for this? Can I connect to the MSSQL data from Access using a method other than ODBC?

Thanks in advance.


 
Status
Not open for further replies.

Similar threads

PrimoSteve
  • Locked
  • Question
Grid From 1
2
Replies
21
Views
2K
PrimoSteve
PrimoSteve
Kennelbloke
  • Locked
  • Solved
Subform not updating in parent form
Replies
10
Views
561
Kennelbloke
Kennelbloke
PrimoSteve
  • Locked
  • Question
Fill in 2nd Textbox2 from Textbox1
Replies
3
Views
442
PrimoSteve
PrimoSteve
TrekBiker
  • Locked
  • Question
Form Data Not Updating
Replies
6
Views
478
dhookom
dhookom
TomSalvato
  • Locked
  • Question
Getting the Monday date from a week number 1
Replies
2
Views
543
TomSalvato
TomSalvato

Part and Inventory Search

Sponsor

Back
Top