R
RFrechette
I hope I’ve posted this in the correct forum. I am not a programmer. I’ve
researched this problem quite a bit and the things I’ve found on the Internet
and in books are above my head.
I have an Access 2000 database that is using SQL as a back end. I have 32
SQL tables linked to Access using ODBC.
I have a production SQL database called Billing. I have a testing SQL
database called Billing_TEST. The tables in the databases are identical
(except for the data). I need to have a button (or two) on my form that will
allow me to change the datasource from Billing to Billing_TEST and back
again. I also need a text box that shows which datasource I am currently
using.
I hope I’ve given you enough information regarding this issue. I would
appreciate any help with this. I am really stuck.
Thanks, rjf
researched this problem quite a bit and the things I’ve found on the Internet
and in books are above my head.
I have an Access 2000 database that is using SQL as a back end. I have 32
SQL tables linked to Access using ODBC.
I have a production SQL database called Billing. I have a testing SQL
database called Billing_TEST. The tables in the databases are identical
(except for the data). I need to have a button (or two) on my form that will
allow me to change the datasource from Billing to Billing_TEST and back
again. I also need a text box that shows which datasource I am currently
using.
I hope I’ve given you enough information regarding this issue. I would
appreciate any help with this. I am really stuck.
Thanks, rjf