Hi All,
An issue has arisen in my database that I believe is highlighting my naivety regarding differences between how data is stored internally to Access and on SharePoint.
I am working with Access 2007 and Sharepoint 2010.
I have run: "Move to sharepoint" on the database. As I am using Access 2007, I am moving only the tables. Access reports no errors (except for the loss of some field validation rules).
There is one particular split form on which users can click a button to unlocks specified controls, allowing them to input data. I have verified that the controls are indeed being unlocked; however, it is remaining the case that users cannot input data.
In the otherwise identical version of my database from before I moved the tables to SharePoint the procedure works. So I am confident that my code (that also performs other tasks, and therefore includes fairly significant amounts of VBA) is working as intended.
In case it should be of interest:
Also, I am able to edit other subform controls that point to related records, so I think it is the Record Locks property that is responsible for locking the record for editing. If that is the case then I do not understand (A) how the record is being deemed to be edited at present and (B) why that is not the case when my tables are internal to access. I cannot disable this property as the database will have multiple users.
There is no chance that anyone else has been accessing the records, therefore locking them, as other users are not aware that the lists exist.
I can provide more regarding the method if required, but I think I'd benefit from some guidance first, as there is a lot of information I could provide, most of which I expect will not be very pertinent.
Thank you for any help you can offer.
An issue has arisen in my database that I believe is highlighting my naivety regarding differences between how data is stored internally to Access and on SharePoint.
I am working with Access 2007 and Sharepoint 2010.
I have run: "Move to sharepoint" on the database. As I am using Access 2007, I am moving only the tables. Access reports no errors (except for the loss of some field validation rules).
There is one particular split form on which users can click a button to unlocks specified controls, allowing them to input data. I have verified that the controls are indeed being unlocked; however, it is remaining the case that users cannot input data.
In the otherwise identical version of my database from before I moved the tables to SharePoint the procedure works. So I am confident that my code (that also performs other tasks, and therefore includes fairly significant amounts of VBA) is working as intended.
In case it should be of interest:
Also, I am able to edit other subform controls that point to related records, so I think it is the Record Locks property that is responsible for locking the record for editing. If that is the case then I do not understand (A) how the record is being deemed to be edited at present and (B) why that is not the case when my tables are internal to access. I cannot disable this property as the database will have multiple users.
There is no chance that anyone else has been accessing the records, therefore locking them, as other users are not aware that the lists exist.
I can provide more regarding the method if required, but I think I'd benefit from some guidance first, as there is a lot of information I could provide, most of which I expect will not be very pertinent.
Thank you for any help you can offer.
