Access-reports from outside an .adp?

  • 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

  • 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


  • 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