Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Location
    london uk
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    access 2.0 (2000)

    I have a legacy application (Access 97) that updates an Access 2.0 application. As part of an upgrade, the access 97 application is being upgraded to Access 2000 with a SQL 2005 backend, but it still needs to update the Access 2.0 system. The original method won't work because the Access 2.0 attachments are now read-only. Is there any way round this?. I've tried DAO but I get the same problem.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: access 2.0 (2000)

    What do you mean by Access 2.0 attachments? Do you mean linked tables?

  3. #3
    New Lounger
    Join Date
    Jul 2001
    Location
    london uk
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: access 2.0 (2000)

    yes. They are linked and unlinked as part of the update process

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: access 2.0 (2000)

    I assume that you have good reasons to stay with such an antiquated setup. I'm afraid I cannot help you with this, sorry.

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: access 2.0 (2000)

    Is there any particular reason you continue to use such old versions of Access? Even the Access97 application you are upgrading, you are only upgrading to Access2000!

    I'm even a little surprised you can even the Access 2.0 tables from the later versions of Access. Microsoft dropped support for Access 2.0 a long time ago.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: access 2.0 (2000)

    Even Access 2007 can import and link to Access 2.0 tables - see Import or link to data in another Access database.

    If the Access 2.0 database contains proprietary, locked code it might be impossible to upgrade without rewriting the whole application.

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: access 2.0 (2000)

    I got the linking confused with the Database Conversion function, which will only look back to Access97.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •