I am using a split database in Access 2010. I'd like to create a new B/E file, leaving the current B/E alone via VBA code. But I want the new B/E file to have a new name (user generated), and have all data in the tables in the new B/E file deleted. And then also have the new B/E file compacted and repaired.
Can this be done via VBA code?