T
thriveni
I use access 2000.
I have multiple reports in an access db that access a
couple of linked tables from SQL. There are 2 servers with
the same copy of database, one is for testing and one is a
production server. when i tried changing from the testing
to the production server (using control panel - ODBC
option) , the reports still access the test server for its
database. the same above method works for forms but not in
reports. I would appreciate if anybody can help .
thriveni
I have multiple reports in an access db that access a
couple of linked tables from SQL. There are 2 servers with
the same copy of database, one is for testing and one is a
production server. when i tried changing from the testing
to the production server (using control panel - ODBC
option) , the reports still access the test server for its
database. the same above method works for forms but not in
reports. I would appreciate if anybody can help .
thriveni