Here is my situation. I have a back end database and a front end. We will call them DBFront and DBBack. I have two more databases (Front end and back end) called DBUserFront and DBUserBack. What I want to do is use DBFront to export tables from DBBack to DBUserBack. I know how to do a straight export if the tables were in DBFront, but they are not. Any help will be much appreciated.
The reason I don't want to just link DBUserBack to DBBack is because I need to be able to do maintenance to DBBack during the day.