Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Importing Reports through Access

Discussion in 'Information Technology' started by ryansarmy, Jul 28, 2006.

  1. ryansarmy

    ryansarmy
    Expand Collapse
    Guest

    Hello, a few months ago I started creating reports for an .MDB that
    resides on another developer's computer. Everytime we wanted to merge
    data he would import forms/reports/queries from my computer, it seems
    my reports would lose certain items. Such as the "order by" in a report
    or a query relationship. After the merge I would copy another .MDB and
    start making changes again. My question is has anyone ever had this
    problem, and I understand that Visual Source Safe is the best way to
    go. I am just trying to prove my case so we can move to that.


    Thanks,

    Ryan Sarmast
     
  2. Loading...


  3. Rick Brandt

    Rick Brandt
    Expand Collapse
    Guest

    ryansarmy wrote:
    > Hello, a few months ago I started creating reports for an .MDB that
    > resides on another developer's computer. Everytime we wanted to merge
    > data he would import forms/reports/queries from my computer, it seems
    > my reports would lose certain items. Such as the "order by" in a
    > report or a query relationship. After the merge I would copy another
    > .MDB and start making changes again. My question is has anyone ever
    > had this problem, and I understand that Visual Source Safe is the
    > best way to go. I am just trying to prove my case so we can move to
    > that.


    Reports (for the most part) ignore the sorting of the underlying query. You
    need to set the sort order you want using the Sorting/Groupng dialog that is
    available in the design view of the report. That should definitely stay
    with the report as it is imported/exported.



    --
    Rick Brandt, Microsoft Access MVP
    Email (as appropriate) to...
    RBrandt at Hunter dot com
     
  4. ryansarmy

    ryansarmy
    Expand Collapse
    Guest

    Thanks Rick, that did work through importing. I guess now I have a
    follow up question. What is the best way for two Access developers to
    work on the same MDB at the same time? We both edit tables/forms and
    reports so I guess I don't see how spliting the MDB could work. Also, I
    am new to Visual Source Safe and I have googled what I can about it,
    half of what I have read leads me to believe that two people can not
    have the same MDB checked out at the same time. Importing is not
    working for us because of the amount of changes being made to various
    objects.

    I am hoping it is a simple answer that I just don't know. Thanks
    for any help

    Ryan Sarmast
     

Share This Page