So i am in the making of a front end user database.
I tried to first spilt me DB into a FE & BE but i ran into a problem. When i begain the database spliting to create the back end, the new DB has no data in it! WHy does this happen?
Here are screen shots...
AS you can see this is my original DB, 1 thing to mention is taht all of the tables i have are linked in from other servers.. this is the only thing i can think of that is messing me up....
Once I run the "Spilt" i end up getting this error message:
Then when i open up the BE database there is no data!
Can someone please tell me how i can get this to split properly