My reports some how got corrupted. I have a prior not up to date database that I could transfer the reports to the current database. Is there someone that could assist??
My reports some how got corrupted. I have a prior not up to date database that I could transfer the reports to the current database. Is there someone that could assist??
What assistance do you need? Use the Import/Export wizard.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I think that will build a new report. I want to insert an existing one.
The wizard will import whatever you select. If report exists with same name then the import will have a number suffix (ReportName1). Delete the old report, rename the import.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Like June7 said, you need to import a copy of the reports. You don't need to build them from scratch. You might need to rename them or reconnect them if any of the table or field names have changed.
First, back up your current database for safety.
Second, make a test copy of your database.
Third, from the test copy, do this -
Then test each report to see if it is working as expected.Code:On the External data tab, in the import and link group, Click Access On the Get External Data dialog box, Select the old file Click import tables, queries, etc Click okay In the Import dialog box, Select the reports tab Select the reports you want to import Click Okay All those reports will be imported
Thank you Dal Jeanis. Got and is all good. Thanks so much for your help.