I have been working successfuly with VBA Data Providers for a few weeks now and something strange just started happening when I execute a refresh. The following is the sequence of events:
- The data provider was created. It pulls data from an Access database and I subsequently use the data in conjunction with data from a repository based data provider. IT HAS BEEN WORKING GREAT FOR A FEW WEEKS.
- I made about 4 hours worth of changes to the report layout.
- I made a change to the sql statement, due to a database structure change, used by the vba data provider.
- I saved the Business Objects report to a new file name.
- I closed the old version of the report. Only the new version is active.
- I refresh the new version.
- I get the DMA0007 error saying the vba data provider could not be refreshed.
- After mucking around for while with this I opened up the earlier version of the report and found that I could still refresh it (I made the appropriate changes to the SQL string in the old version)
- I switch to the new version of the report and refresh and it works fine.
- I close the old version of the report and the new version does not refresh.
- I copied the code from the old to the new and it will not refresh unless the old version of the report is loaded.
It appears as if the new version of the report wants to only run the code present in the old version. I may be doing something really stupid and your thoughts are appreciated.
dmontella (BOB member since 2004-07-15)