A
arbeiter
Hi,
I am a programmer familiar w/ Access, but not an expert by any means.
I need to take an old Access Database that has over 100 subreports and
tear it apart and attempt to optimize the structure of the database.
My problem comes into play when I attempt to move these reports to my
new Access Database. Since many of the tables have changed names,
along with queries and forms, the access reports will obviously fail.
I need to figure out what the reports are attempting to do. Is there a
way to see where it is collecting any statistics from and what fields
it is grabbing. Some of the forms are written into the VBA code, and I
do not have a problem with these, its the reports that are auto
generated by access.
Thanks in advance for the help
arbeiter
I am a programmer familiar w/ Access, but not an expert by any means.
I need to take an old Access Database that has over 100 subreports and
tear it apart and attempt to optimize the structure of the database.
My problem comes into play when I attempt to move these reports to my
new Access Database. Since many of the tables have changed names,
along with queries and forms, the access reports will obviously fail.
I need to figure out what the reports are attempting to do. Is there a
way to see where it is collecting any statistics from and what fields
it is grabbing. Some of the forms are written into the VBA code, and I
do not have a problem with these, its the reports that are auto
generated by access.
Thanks in advance for the help
arbeiter