Welcome to SPN

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

Sign Up Now!

Existing access application will not run in Access 2003

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

  1. FiBee

    FiBee
    Expand Collapse
    Guest

    We have MDAC 2.8 on pc (XP Service Pack 2) and existing Microsoft Access
    application will not run on Access 2003. Runs fine in Access 2000.

    Prob is that many of our customers who are due for an database upgrade are
    running Access 2003, at the moment the only way we can see to resolve this
    is to ask our customers to downgrade to Access 2000.

    Would be very grateful for any help.

    Thanks
     
  2. Loading...


  3. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    What's the problem? "will not run" doesn't give us much to go on...

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


    "FiBee" <FiBee@discussions.microsoft.com> wrote in message
    news:F0D4DFE7-95AC-4B61-917F-340E430B8916@microsoft.com...
    > We have MDAC 2.8 on pc (XP Service Pack 2) and existing Microsoft Access
    > application will not run on Access 2003. Runs fine in Access 2000.
    >
    > Prob is that many of our customers who are due for an database upgrade are
    > running Access 2003, at the moment the only way we can see to resolve

    this
    > is to ask our customers to downgrade to Access 2000.
    >
    > Would be very grateful for any help.
    >
    > Thanks
     
  4. FiBee

    FiBee
    Expand Collapse
    Guest

    Hi Douglas - thanks for getting back to me

    basically if we try to open any form that has ADODB connections the 'an
    error has ocurred - do you want to inform Microsoft' box appears and Access
    then hangs/shuts down

    (other forms that do not have ADODB connections load and run ok)

    I think the problem lies with MDAC - we installed office 2003 on an xp
    machine with XP SP 2 I think it may be MDAC 2.81 causing the problem???



    but not sure how to downgrade 2.81 to 2.8 (or if indeed this is the problem)
    or how to find out what version of MDAC is running.

    "Douglas J Steele" wrote:

    > What's the problem? "will not run" doesn't give us much to go on...
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "FiBee" <FiBee@discussions.microsoft.com> wrote in message
    > news:F0D4DFE7-95AC-4B61-917F-340E430B8916@microsoft.com...
    > > We have MDAC 2.8 on pc (XP Service Pack 2) and existing Microsoft Access
    > > application will not run on Access 2003. Runs fine in Access 2000.
    > >
    > > Prob is that many of our customers who are due for an database upgrade are
    > > running Access 2003, at the moment the only way we can see to resolve

    > this
    > > is to ask our customers to downgrade to Access 2000.
    > >
    > > Would be very grateful for any help.
    > >
    > > Thanks

    >
    >
    >
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    The first thing I'd try is decompiling your application. Tony Toews has
    instructions at http://www.granite.ab.ca/access/decompile.htm

    To check what version of MDAC is running, see
    http://www.microsoft.com/downloads/...F6-4A21-4B43-BF53-14332EF092C9&displaylang=en

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


    "FiBee" <FiBee@discussions.microsoft.com> wrote in message
    news:6533D301-4F1D-42BB-AE2F-EF00A0F2331B@microsoft.com...
    > Hi Douglas - thanks for getting back to me
    >
    > basically if we try to open any form that has ADODB connections the 'an
    > error has ocurred - do you want to inform Microsoft' box appears and

    Access
    > then hangs/shuts down
    >
    > (other forms that do not have ADODB connections load and run ok)
    >
    > I think the problem lies with MDAC - we installed office 2003 on an xp
    > machine with XP SP 2 I think it may be MDAC 2.81 causing the problem???
    >
    >
    >
    > but not sure how to downgrade 2.81 to 2.8 (or if indeed this is the

    problem)
    > or how to find out what version of MDAC is running.
    >
    > "Douglas J Steele" wrote:
    >
    > > What's the problem? "will not run" doesn't give us much to go on...
    > >
    > > --
    > > Doug Steele, Microsoft Access MVP
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "FiBee" <FiBee@discussions.microsoft.com> wrote in message
    > > news:F0D4DFE7-95AC-4B61-917F-340E430B8916@microsoft.com...
    > > > We have MDAC 2.8 on pc (XP Service Pack 2) and existing Microsoft

    Access
    > > > application will not run on Access 2003. Runs fine in Access 2000.
    > > >
    > > > Prob is that many of our customers who are due for an database upgrade

    are
    > > > running Access 2003, at the moment the only way we can see to resolve

    > > this
    > > > is to ask our customers to downgrade to Access 2000.
    > > >
    > > > Would be very grateful for any help.
    > > >
    > > > Thanks

    > >
    > >
    > >
     
  6. FiBee

    FiBee
    Expand Collapse
    Guest

    Many thanks Doug - I'll give this a try

    Kind Regards



    "Douglas J Steele" wrote:

    > The first thing I'd try is decompiling your application. Tony Toews has
    > instructions at http://www.granite.ab.ca/access/decompile.htm
    >
    > To check what version of MDAC is running, see
    > http://www.microsoft.com/downloads/...F6-4A21-4B43-BF53-14332EF092C9&displaylang=en
    >
    > --
    > Doug Steele, Microsoft Access MVP
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "FiBee" <FiBee@discussions.microsoft.com> wrote in message
    > news:6533D301-4F1D-42BB-AE2F-EF00A0F2331B@microsoft.com...
    > > Hi Douglas - thanks for getting back to me
    > >
    > > basically if we try to open any form that has ADODB connections the 'an
    > > error has ocurred - do you want to inform Microsoft' box appears and

    > Access
    > > then hangs/shuts down
    > >
    > > (other forms that do not have ADODB connections load and run ok)
    > >
    > > I think the problem lies with MDAC - we installed office 2003 on an xp
    > > machine with XP SP 2 I think it may be MDAC 2.81 causing the problem???
    > >
    > >
    > >
    > > but not sure how to downgrade 2.81 to 2.8 (or if indeed this is the

    > problem)
    > > or how to find out what version of MDAC is running.
    > >
    > > "Douglas J Steele" wrote:
    > >
    > > > What's the problem? "will not run" doesn't give us much to go on...
    > > >
    > > > --
    > > > Doug Steele, Microsoft Access MVP
    > > > http://I.Am/DougSteele
    > > > (no e-mails, please!)
    > > >
    > > >
    > > > "FiBee" <FiBee@discussions.microsoft.com> wrote in message
    > > > news:F0D4DFE7-95AC-4B61-917F-340E430B8916@microsoft.com...
    > > > > We have MDAC 2.8 on pc (XP Service Pack 2) and existing Microsoft

    > Access
    > > > > application will not run on Access 2003. Runs fine in Access 2000.
    > > > >
    > > > > Prob is that many of our customers who are due for an database upgrade

    > are
    > > > > running Access 2003, at the moment the only way we can see to resolve
    > > > this
    > > > > is to ask our customers to downgrade to Access 2000.
    > > > >
    > > > > Would be very grateful for any help.
    > > > >
    > > > > Thanks
    > > >
    > > >
    > > >

    >
    >
    >
     

Share This Page