I have a certain few tables I want to move to a back end, but the Database Splitter takes them all and makes them linked tables. I may want to do this, but not yet. I am still in development and this would cause some recurring testing problems.
So, I create a back end and import the chosen tables. Then when I go to my front end I want to replace my existing table with a new linked table, Access won't let me do so without deleting the original along with all of its relationships, something I don't want to do.
Any ideas?
Paul