I have a split database, and have the back end on a server. This is the setup:
Server - back end
Workstation 1 - Editable front end
Workstation 2 - uneditable front end
Workstation 3 - uneditable front end
Workstation 4 - uneditable front end
My database has one single form in which the users browse, edit and add records. Obviously on workstations 1,2 and 3 the users can only browse that data that is seen in the forms.
My form contains some command buttons such as a search, find previous record, find next record and add record.
At the bottom of the screen is the smaller navigation buttons and a number telling the user how many records are in the database. Obviously all of you have seen that.
Now, if the user on workstation 1 was to edit record 45 for example then the users on the others pc's would see those edits providing the user on workstation leaves the record and goes to another - not a problem seems fine to me.
However, my main gripe at the moment is that when the user on workstation 1 uses the add record button to add a record it does get transfered to the table in the back end and available for everyone to see on the other databases...well kind off...the user will have to exit the form and go back into the form to see the latest record addition.
If the user on the editable database form adds a new record to make the total amount of records stored to say 1000, it will only show as 999 on the other work stations at the bottom of the screen/form window...Obviously I want all the front ends on the other workstations to have forms in which the very latest data is shown
Is there a way to sort this out without having the users exit the forms and reload them to see the additional record additions in the form.
Name of from 'details'
name of table 'tbldetails'
Every time a record is added the job number must always be inputted such as 456,then on another record addition it will be 457 and so on. That's the unique identifier of my records. 'txtjob_number'
I hope I've provided as much information as possible and any help would be great, thanks.
Server - back end
Workstation 1 - Editable front end
Workstation 2 - uneditable front end
Workstation 3 - uneditable front end
Workstation 4 - uneditable front end
My database has one single form in which the users browse, edit and add records. Obviously on workstations 1,2 and 3 the users can only browse that data that is seen in the forms.
My form contains some command buttons such as a search, find previous record, find next record and add record.
At the bottom of the screen is the smaller navigation buttons and a number telling the user how many records are in the database. Obviously all of you have seen that.
Now, if the user on workstation 1 was to edit record 45 for example then the users on the others pc's would see those edits providing the user on workstation leaves the record and goes to another - not a problem seems fine to me.
However, my main gripe at the moment is that when the user on workstation 1 uses the add record button to add a record it does get transfered to the table in the back end and available for everyone to see on the other databases...well kind off...the user will have to exit the form and go back into the form to see the latest record addition.
If the user on the editable database form adds a new record to make the total amount of records stored to say 1000, it will only show as 999 on the other work stations at the bottom of the screen/form window...Obviously I want all the front ends on the other workstations to have forms in which the very latest data is shown
Is there a way to sort this out without having the users exit the forms and reload them to see the additional record additions in the form.
Name of from 'details'
name of table 'tbldetails'
Every time a record is added the job number must always be inputted such as 456,then on another record addition it will be 457 and so on. That's the unique identifier of my records. 'txtjob_number'
I hope I've provided as much information as possible and any help would be great, thanks.