Hi All,
Is there any way to Archive reports so that they dont add to the file size of the mdb file?
I have a reports with names like
rptSummary20030127
rptSummary20030112
rptSummary20020916
The numbers at the end is the date in yyyymmdd format.
They are the same report but the text of these reports change periodically. But the older reports are valid as well, though they are viewed very few times.
My table data is something like this
Customer Date printed(mm/dd/yy) Report used
00134 02/04/03 rptSummary20030127
00135 01/01/03 rptSummary20020916
So if i want to view a printed record I just pull up the correct report for that record.
The problem here is that the reports are getting a bit too much, is there any way that I can move these reports, to say another access application and then bring them back only when i need it.
Can a report be stored as a database record and just instantiated like an object? Something like storing a word doc in an image field in SQL Server?
Thanx Solomons
Is there any way to Archive reports so that they dont add to the file size of the mdb file?
I have a reports with names like
rptSummary20030127
rptSummary20030112
rptSummary20020916
The numbers at the end is the date in yyyymmdd format.
They are the same report but the text of these reports change periodically. But the older reports are valid as well, though they are viewed very few times.
My table data is something like this
Customer Date printed(mm/dd/yy) Report used
00134 02/04/03 rptSummary20030127
00135 01/01/03 rptSummary20020916
So if i want to view a printed record I just pull up the correct report for that record.
The problem here is that the reports are getting a bit too much, is there any way that I can move these reports, to say another access application and then bring them back only when i need it.
Can a report be stored as a database record and just instantiated like an object? Something like storing a word doc in an image field in SQL Server?
Thanx Solomons
