Access 2007 manually split database

 · Create a new, blank database file. Goto File. Click on Get External Data. Click on Import. Select the back end file. Click on Options. Under Import Tables click on Definition Only. Click Okay. Making sure that the new file is not in the same folder/location as the original backend, rename it the same as the back end.  · Access has a tool to do the splitting for you, go to: ToolsDatabase Utilities Database Splitter. In Access +: On the Database Tools tab, in the Move Data group, click Access Database. In the Database Splitter dialog box, click Split Database. Type .  · In Access , click the Office button and then click the Access Options button. Select Current Database in the left pane and you'll find these options in .

Access Database can be split into either a front-end application or a back-end application. After this splitting procedure, back-end database contains tables and it gets stored on file server. Whereas, the front-end database links contains all the forms, queries, reports, macros, and modules. You can manually split your database by: Copy it Delete all the non-table objects from one of them and make that your back-end database Delete all the tables from the front-end database Link the front-end database to the tables in the back-end database. Have you tried Manually spliting the database? Take 2 copies of your database, copy 1 of them onto the server. Open that database up and delete all the forms, queries, reports etc - just leave the tables. Then open the other copy of the database and delete the tables, then go to EXTERNAL DATA ACCESS (under the import section).

Compared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal. Access doesn't have a Database window, but you can hide the A split database is easier to protect than a single database that. 8 may accdb” (Access and later) to that name to distinguish it as an Access file. “Split” Databases. All the databases I create are split into.