Copy Access tables from one BE database to another BE database
Posted on 2014-01-25
Having a brain cramp this afternoon, must be these freezing temperatures.
Have a backend database with about 50 tables. I need to create another BE with identical table structures, indices, relationships, ... but with empty tables (at least most of them will be empty), via VBA code, from my FE
Just cannot seem to get a handle on this today. I know I could copy the entire BE, then loop through the tables I want cleaned out and delete all the records, but I would have to do that in the proper order or end up with referential integrity issues. I'm looking for something a bit more elegant.