Hi Guys,
I have a query about splitting a database, and then restricting access to certain forms.
I have a table with 5,500 exchanges in. I then have another table of 'jobs' which are all allocated to certain exchanges. When the user loads up the database, they are presented with a form which contains a combo box of all the exchanges, so they can select which one they are going to work with. Once one is selected, in a subform of the main form, a subform is loaded which shows all the jobs in the 'jobs' table, that are allocated to the selected exchange. For each job, there is a 'More details' button which links the user to another form containing all the job information (editable data).
Thats the basic theory behind it. I have split the database now... and am having a few troubles with read/write access. I want it so if one person goes into the 'More Details' of any one job (from any one exchange), then if another user tries to access the same job information, they are notified that another user is editing it, and that they have it in an almost 'read only' fassion.
We've tested how access manages this by default and it's not how we want it. We want the users to be told if its 'read only' and then all data from that sheet is then locked from editing until the user comes out and goes back again.
All help greatly appreciated,
Taz
I have a query about splitting a database, and then restricting access to certain forms.
I have a table with 5,500 exchanges in. I then have another table of 'jobs' which are all allocated to certain exchanges. When the user loads up the database, they are presented with a form which contains a combo box of all the exchanges, so they can select which one they are going to work with. Once one is selected, in a subform of the main form, a subform is loaded which shows all the jobs in the 'jobs' table, that are allocated to the selected exchange. For each job, there is a 'More details' button which links the user to another form containing all the job information (editable data).
Thats the basic theory behind it. I have split the database now... and am having a few troubles with read/write access. I want it so if one person goes into the 'More Details' of any one job (from any one exchange), then if another user tries to access the same job information, they are notified that another user is editing it, and that they have it in an almost 'read only' fassion.
We've tested how access manages this by default and it's not how we want it. We want the users to be told if its 'read only' and then all data from that sheet is then locked from editing until the user comes out and goes back again.
All help greatly appreciated,
Taz
