Is there any way to recombine a database once it has been
split into a back end/front end database?
Back up the frontend... you're going to demolish it in the course of
this.
CHECK YOUR BACKUP. Does it work? Good!
Now open the frontend, and open the Tables tab of the database window.
Select all the linked tables, and click the Delete key - yep, delete
all your tables. (See what I mean about the backup!?)
Now select File... Get External Data... Import. Navigate to the
backend database and select all the tables; Import them into what was
the frontend, is now an empty shell, and will now be an integral
database.
