Hello all,
I have a problem where I have two databases. One is split and the other is not. Both of these have a Form which users use to look up data or insert data. Is there a way to link the forms to the back-end of the split database so you have two forms pointing to the same place? This case being the split front end form and the non split form pointing to the split database back end.
What's the best way to go about this? Users from both database can't see what the other inserted or modified, so trying to make them both look at the same tables is what I'm trying to do.
Thank you
I have a problem where I have two databases. One is split and the other is not. Both of these have a Form which users use to look up data or insert data. Is there a way to link the forms to the back-end of the split database so you have two forms pointing to the same place? This case being the split front end form and the non split form pointing to the split database back end.
What's the best way to go about this? Users from both database can't see what the other inserted or modified, so trying to make them both look at the same tables is what I'm trying to do.
Thank you