jgsteeldev
Programmer
I have an interesting problem. I started a new job two weeks ago. I was shocked to find out that the company I now work for does not have a test environment. I mentioned how necessary a test environment is because of the risk to the integrity of the production data and was tasked with setting up a tst environment. Here is my situation.
Most of the applications here are written in Access 97 or Access XP. They are mdb front ends that stroe the data in a SQL Server. All of the connection to the SQL server have been done by linking to the tables using a DSN. I need to be able to create a Macro or maybe a code module that breaks the connections to the production server and re-connects the linked tables to the test server. I also need to be able to go in reverse. I come from a VB6 background where we connected to the database using a UDL so when we need to switch from test to prod we just changed the udl. I have some experience in Acces but no tmuch. But, i told my boss that I am sure that I can set up the test server just fine, So, I need some help.
Rock Chalk KU!!!!
Most of the applications here are written in Access 97 or Access XP. They are mdb front ends that stroe the data in a SQL Server. All of the connection to the SQL server have been done by linking to the tables using a DSN. I need to be able to create a Macro or maybe a code module that breaks the connections to the production server and re-connects the linked tables to the test server. I also need to be able to go in reverse. I come from a VB6 background where we connected to the database using a UDL so when we need to switch from test to prod we just changed the udl. I have some experience in Acces but no tmuch. But, i told my boss that I am sure that I can set up the test server just fine, So, I need some help.
Rock Chalk KU!!!!