Automating Access Database Functions

Hi all,

I'm attempting to write a script which will split a database into it's front-end/back-end parts via code, to assist in a access 97 -> 2000 migration.

I could do this through the GUI, but there are way too many databases in question to be doing manually.

I've heard about something called a macro recorder. My best try at this so far will be to record as I do a split, then modify the code resulting, but I'm not having much luck.

Does anyone have ideas where I might find functions which do this? db.split( db.name, parameters )..

Thanks in advance,

Wes.