November 10, 2004 at 3:50 pm
Hello!
We have a central SQL-server containing our data.
Against this we run an .adp-client. This .adp-file
contains about 20k lines of (mostly interface-related)
VB-code. In addition, and this is the killer, it has
about 150 Access-reports. Now, a lot these reports contains
bitmaps, and the .adp-file now stands at a size of about 55 mb
after compression. It's getting to a point where
redistributing the .adp is slowly starting to become painful
because of it's size. Since these reports don't change
all that much we would like to have a central .mdb or .adp
repository that would contain these reports, thus making
the redistributed .adp-client much smaller (since it would then contain solely the code and the forms, no reports).
In other words, we would like to "link in" REPORTS, pretty
much the same as can you link in tables or code from another
Access-file.
Is this at all possible ?
Regards,
Moussie
November 10, 2004 at 8:45 pm
If you right-click/properties on a picture in an Access report (design mode), you can change the 'Picture Type' to 'linked' (default is 'embedded'). So the pictures can be stored once on a central server to which everyone has access and taken out of the individual Access dbs.
Regards
Phil
November 12, 2004 at 9:36 am
yup, use linked images or set up a crystal reports server and go from there.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply