Thanks for you both replies. I modified Northwind Traders and tried to split the data into FE andBE. It didn't work. I converted Macros to VBA. The database even didn't run before splited.
I used the tool to convert Macro to VBA. But it kept showing : The data macro 'Settings.Gettings' could not be found. Can you please explain a little more in details how to replace Macros with VBA? Thanks!