C
Chip Coutts
As to item 2), splitting a database, then putting both the
FE and BE on the server, does not make sense. Typically,
when you split a database, you put the FE on the local
PCs, and the BE on the server. This improves performance
by reducing network traffic, since the local PCs do not
have to look to the server for forms, reports, etc. If you
have both the FE and the BE on the server, then the
primary benefit for splitting is lost, and the database
may as well be not split...
FE and BE on the server, does not make sense. Typically,
when you split a database, you put the FE on the local
PCs, and the BE on the server. This improves performance
by reducing network traffic, since the local PCs do not
have to look to the server for forms, reports, etc. If you
have both the FE and the BE on the server, then the
primary benefit for splitting is lost, and the database
may as well be not split...