Any advantage Of Splitting with one user? (1 Viewer)

[eirman]

If a database has only one user on one PC, is there any advantage in splitting it into front/back end DBs

 

[CJ_London]

If someone else is maintaining/developing it then yes.

Also, it is simply good practice to have a FE and BE. Front ends can sometime become corrupted which puts the data at risk if it is not split

 

[eirman]

Front ends can sometime become corrupted which puts the data at risk if it is not split

Now that is a good reason ... Thanks

 

[The_Doc_Man]

If you are developing it as you go, you isolate the data from the code and if you hose the code, you lose no data.

If you are backing up your data, you can do a selective backup for data only and perhaps fit it on smaller media (depending on size of the database, of course.)