We have a MS Access Database with millions rows and I need to Split the Front End and Back End. Can the Backend be stored on a Windows Server or a high performance computer? So the developers can connect to the Central Backend Server and DB work is done on the Server and the front end developers using their desktop and not the Backend DB machine.
Used the SPLIT Option in MS ACCESS and works well.
Yes you can but the bottle neck here could be the network, you don't need much power for a split Access database. Access moves a lot of data because of its design. If you query a table then Access will read the whole table from the server to filter it later on the client.
If your frontend is in early state of development consider using sql server (or any database server with odbc) and runing every query in passtrough mode.
Also think in a easy way to distribute the frontend to clients when you make changes.