[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

Access Locking

I have a bound datacontrol  in a VB4 program and I am having problems with the locking schemes that access uses in a multiuser environment.  I am aware of setting the lockedits property for a recordset, is there a way to change the lockedits propert of a bound data control?
0
avellap
Asked:
avellap
1 Solution
 
dansariCommented:
avellap:

The LockEdits property does not apply to a data control directly, but it *does* apply to the Recordset property of the data control.  If you want to set this value, you have to do it in code, e.g. in Form_Load:

Data1.Refresh (necessary if you want to refer to the Recordset property in Form_Load)
Data1.Recordset.LockEdits = True (or whatever)

This answers your question, but I'm not sure it's the question you want to ask - please comment if you want more (other) information.
0
 
avellapAuthor Commented:
I will try this ... the problem I am having is that some users are being locked out when trying to add records.  The Access error that comes up  says that user XXXX on Machine YYYY has the database opened (something like that) and I am assuming that the problem is because of the 2k page locking being performed ... I am hoping that setting the lockedits to false will eliminate this ?????
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now