How to split database into BE and FE

The procedure actually is quite simple. Say you have a database MyCoolDB.mdb. First you create a new database MyCoolDBData.mdb, then you open it and import all table from MyCoolDB.mdb there. Do not forget to check "Import relationships" in Import dialog. Check that all tables are there and close it. Now open your MyCoolDB.mdb, delete all tables and run menu FileGet External DataLink tables. Select all tables from MyCoolDBData.mdb and click OK. Try to run your MyCoolDB.mdb to make sure everything is working as expected. Last thing is to add a routine to relink tables at startup, you can use one from Solutions.mdb sample database or use Dav Ashish code. Now you can move BE (MyCoolDBData.mdb) to a shared drive and relink tables.
Also you can look at article Split your MDB file into data and application by Allen Browne.