Using ado to connect SQL
As shown in figure how to make only the currently logged in user=name column names, to do for the user in the datagrid row data directly modify other user data can not operate
CodePudding user response:
Suggest you modify the interface displays only the records, modify permissions can be set in addition to browse interface, or, in the same interface, switch to view or modify, after all, according to the query again and reset the DataGrid properties,CodePudding user response:
In a different way, such as your need, also can realize,In the DataGrid RowColChange event, whether the value of the name column in the current record is consistent with the expected, if so, open the form change permissions; Otherwise closed, attention, is to use the current column in the recordset object (rs) value comparison,
DataGrid1. AllowUpdate=True
Or
DataGrid1. AllowUpdate=False
CodePudding user response:
However, the way you make the interface properties quietly change constantly, will cause the user confusion,