I am using Access reports from tables linked to Excel sheets.
To create a backdrop for the report, I am using a form format, in another
Excel file, linked to an unbound object frame overlayed over the Access
report. The Access report has controls sourced to the Excel table.
There are several issues with this method. If I keep the Excel file open.
The Access report takes a long time to open. Sometimes hangs and sometimes
either Excel or Access crashes.
The back drop format that is an Excel file is in a multi sheet Excel file.
The link that reads this sheet is set by the file name (source document) and
the range name (source item). However Access uses the sheet that was current
last as the source item and not the range name that is set using the source
item property.
Is there some way to get Access do it right.
I am using MS Office 2003 and Windows XP.