Welcome to SPN

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

Sign Up Now!

Can't overwrite Access frontend

Discussion in 'Information Technology' started by NCRga, Nov 11, 2005.

  1. NCRga

    NCRga
    Expand Collapse
    Guest

    I have a strange situation. A co-worker has created a split database in
    Access 2003. Recently he made changes to the front-end and emailed the new
    version out to the users requesting them to replace their old version with
    this new version. All went well execpt for 2 users that are not in this
    building. These 2 users have deleted all references to the old version, but
    everytime they copy the new version to their computer and open it, it opens
    up the old version! One of the users even tried to open the newer version
    from a copy on a server and it still opened the old version. We can't figure
    this out...can anybody help????
     
  2. Loading...


  3. NCRga

    NCRga
    Expand Collapse
    Guest

    RE: Can't overwrite Access frontend...UPDATE

    I just learned that this front-end was created in Access 97. Access 97 users
    can open the newer version of the front-end with no problem. It is the Access
    2003 users that are having problems. In the past we have always been able to
    create in 97 and open it in 2003 with no problems...even multiple versions of
    the same interface. But in this case, Access 2003 is only wanting to open the
    first version created in Access 97. Any updates to the front-end are not
    visible to 2003 users. I hope I haven't made this too complicated to
    understand. We are beside ourselves trying to figure this out.

    "NCRga" wrote:

    > I have a strange situation. A co-worker has created a split database in
    > Access 2003. Recently he made changes to the front-end and emailed the new
    > version out to the users requesting them to replace their old version with
    > this new version. All went well execpt for 2 users that are not in this
    > building. These 2 users have deleted all references to the old version, but
    > everytime they copy the new version to their computer and open it, it opens
    > up the old version! One of the users even tried to open the newer version
    > from a copy on a server and it still opened the old version. We can't figure
    > this out...can anybody help????
     
  4. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    Re: Can't overwrite Access frontend...UPDATE

    Why not convert a copy of the new Access 97 front-end to Access 2003, and
    let the Access 2003 users try to open that?

    --
    Doug Steele, Microsoft Access MVP
    http://I.Am/DougSteele
    (no e-mails, please!)


    "NCRga" <NCRga@discussions.microsoft.com> wrote in message
    news:BC6193ED-CF95-4BCE-B155-AD635BD8F40E@microsoft.com...
    > I just learned that this front-end was created in Access 97. Access 97

    users
    > can open the newer version of the front-end with no problem. It is the

    Access
    > 2003 users that are having problems. In the past we have always been able

    to
    > create in 97 and open it in 2003 with no problems...even multiple versions

    of
    > the same interface. But in this case, Access 2003 is only wanting to open

    the
    > first version created in Access 97. Any updates to the front-end are not
    > visible to 2003 users. I hope I haven't made this too complicated to
    > understand. We are beside ourselves trying to figure this out.
    >
    > "NCRga" wrote:
    >
    > > I have a strange situation. A co-worker has created a split database in
    > > Access 2003. Recently he made changes to the front-end and emailed the

    new
    > > version out to the users requesting them to replace their old version

    with
    > > this new version. All went well execpt for 2 users that are not in this
    > > building. These 2 users have deleted all references to the old version,

    but
    > > everytime they copy the new version to their computer and open it, it

    opens
    > > up the old version! One of the users even tried to open the newer

    version
    > > from a copy on a server and it still opened the old version. We can't

    figure
    > > this out...can anybody help????
     
  5. NCRga

    NCRga
    Expand Collapse
    Guest

    Re: Can't overwrite Access frontend...UPDATE

    Thanks, but we were trying to keep from having to keep multiples of the same
    interface. This is version 6...we hadn't had this problem before.

    UPDATE: Just found the problem. There is a macro that is named "autoexec"
    that opens up a specific form automatically when the database is opened. I
    told the developer to delete that macro and re-create it. My thought was that
    somehow the macro was opening the old version of that form (which is really
    weird since that version of the form was deleted in the database). He just
    came and told me it worked! Evidently the developer copied the form, made
    changes and then replaced the old form with this new form. I have never seen
    this before and I have been developing in Access for about 10 years! But it
    appears the old form remained in memory and that macro was opening the OLD
    FORM. I'll have to remember that!

    "Douglas J Steele" wrote:

    > Why not convert a copy of the new Access 97 front-end to Access 2003, and
    > let the Access 2003 users try to open that?
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "NCRga" <NCRga@discussions.microsoft.com> wrote in message
    > news:BC6193ED-CF95-4BCE-B155-AD635BD8F40E@microsoft.com...
    > > I just learned that this front-end was created in Access 97. Access 97

    > users
    > > can open the newer version of the front-end with no problem. It is the

    > Access
    > > 2003 users that are having problems. In the past we have always been able

    > to
    > > create in 97 and open it in 2003 with no problems...even multiple versions

    > of
    > > the same interface. But in this case, Access 2003 is only wanting to open

    > the
    > > first version created in Access 97. Any updates to the front-end are not
    > > visible to 2003 users. I hope I haven't made this too complicated to
    > > understand. We are beside ourselves trying to figure this out.
    > >
    > > "NCRga" wrote:
    > >
    > > > I have a strange situation. A co-worker has created a split database in
    > > > Access 2003. Recently he made changes to the front-end and emailed the

    > new
    > > > version out to the users requesting them to replace their old version

    > with
    > > > this new version. All went well execpt for 2 users that are not in this
    > > > building. These 2 users have deleted all references to the old version,

    > but
    > > > everytime they copy the new version to their computer and open it, it

    > opens
    > > > up the old version! One of the users even tried to open the newer

    > version
    > > > from a copy on a server and it still opened the old version. We can't

    > figure
    > > > this out...can anybody help????

    >
    >
    >
     

Share This Page