i thought i have done this once, but a while ago. and now i can't recall, so i'm hoping to get some feedback here.
isn't there a way to duplicate a database's structure without the records? i just want the structure itself. i've read that i can copy a table, close the database, open a new database, and paste the table. however, i want this for all the objects in the database, not just tables.
i've opened a new database, then went to tables > new > import table, which then opens another window.
i've selected all the objects, and w/in the options button, selected definitions only (not data). got all the objects, however, when i try to open one, i get a message stating it can't find a macro.
when i look in the macros, only autoexec was there. i've redone w/importing that and still not getting anything. (fyi, this database was set up such that when the database opens, a form "menu" is the default opening. there's a lot of vba, but the form menu wasn't created using the switchboard capabilities.)