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

eirman

Registered User.
Local time
Today, 13:53
Joined
Aug 16, 2013
Messages
38
If a database has only one user on one PC, is there any advantage in splitting it into front/back end DBs
 

CJ_London

Super Moderator
Staff member
Local time
Today, 13:53
Joined
Feb 19, 2013
Messages
16,553
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

Registered User.
Local time
Today, 13:53
Joined
Aug 16, 2013
Messages
38
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

Immoderate Moderator
Staff member
Local time
Today, 08:53
Joined
Feb 28, 2001
Messages
26,999
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.)
 

Users who are viewing this thread

Top Bottom