I have a database split between front end and back end, and I want to merge them back together. The reason for this is that the front end has a lot of forms that I want to preserve, but I also want to move the backend tables to SharePoint. If I can move the tables from the back end into the front end, I can then distributre the single database to my users, who will be able to use the forms while accessing the Sharepoint lists. I realize that I can keep them separate and achieve the same goal, but each user would have to make sure to keep the front end and back end linked on their own system (these users will be on different networks).

So, is there a way to "unlink" the tables and import them into the front end?

Thanks!!