The way datasource update works for me on a local Access database is different than how it works when connecting to SQL Server. In both cases I have the identical database in two locations, just one named "Live" and one named "Test".
On the local Access database all tables are updated to the...
MisterMo,
I thought that all tables would automatically re-map as you are saying, but they do not.
I update the report to use the 'Live' database in the "Replace With" list instead of the 'Test' database currently selected for the report, but the results do not change. The data on the...
I'm having a similar issue. In the 'Set Datasource Location' screen do you have to update both the database and each individual table used in the report? I was thinking by udating the location from 'Live' to 'Test' all of the tables used in the report would also be updated.
Just a pain to do...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.