Excuse me, I am afraid I don't fully understand.
You meant I need to split all the machines data into separate FE and one BE for them all?
Or FE and BE for every machine separately?
The standard setup for a networked application is to have a BE file on the network and a copy of the FE on each workstation.
By doing that, all data will be in one place and you can just make backups of that BE.
This means far less maintenance work for you/admins.
However, if your workstations are not on a network, you will need to have a separate BE on each workstation and do backups of each of them.
Either way, if for any reason any of the FEs get damaged, you can just replace with a fresh copy without any data loss.
Whereas at the moment if/when you get corruption, you risk losing all data from that workstation.
The main reasons for splitting a single user db are
- if you need to do fe design changes (e.g. add a form) you do it in your development copy then replace the production copy with the changes. Thus you don't have to be concerned with the data portion.
- if you corrupt the un-split db to the point where you cannot even open it, in all probability you have lost all data.
This might have already been mentioned here but it's worth repeating.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Thank you so much for your help.
Can you recommend a good tutorial for splitting the database the right way?
To ensure there won't be any problems in the future
Maybe a possibility: ask the IT guys to create a SQL (express) database with the proper securities set for your application, that you can link to with access :
* no more problems with stability
* you have one database every machine can link to
* the IT DBA can set up a good automatic backup plan, so you save a lot of time every evening
* no more security issues: this can be done far better and easier in the SQL database than using access VBA
* Access works fine as a front end to SQL server
It's worth a question and a far more stable solution.