Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Access 97/2000 (in)compatibility

    My office has a few Access files that we use from time to time. We built them in Access 97. The corporate geeks came in and installed Access 2000, and now we can't open our Access 97 files. It's incomprehensible how a software vendor (Microsoft) would field a new version of a product that cannot/will not work with files created in earlier versions, but what do I know? Anyway, I've perused this Access forum for messages from folks who have similar problems. The messages I've found get into water that's far deeper than I can manage. There's all this stuff about codes and other stuff that mean nothing to me. Surely there's a way to get into our older files with the new software...or is there? I mean something in plain English, y'know? I'll appreciate the help!

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Access 97/2000 (in)compatibility

    Hi,
    You should be able to convert your Access97 files into Access2000 when you try to open them. If this fails, it's often because the 97 databases weren't compiled. Are you getting an error message? Any chance they kept a copy of 97 so you can open them and make sure they're compiled properly before you try converting them?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 97/2000 (in)compatibility

    When I first started using Access 2000 with my Access 97 databases I encountered far fewer errors if I started out with a new blank database and from the menubar selected File, Get External Data, Import. Select the 97 version database and click import. Click on each tab containing objects such as tables, queries, forms, reports, etc. and click the button for each to select all. Once all the objects from each tab are selected, click OK. All the objects from your version 97 database will now be in your new version 2000 database and you will encounter far fewer error messages.
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Access 97/2000 (in)compatibility

    Here's where I'm going to demonstrate the depth of my knowledge of Access (any version). What do you mean "compiled"? How would I know whether my databases are compiled? And if I discover that they are not compiled, how do I compile them? Thanks!

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Virginia, USA
    Posts
    1,560
    Thanks
    37
    Thanked 1 Time in 1 Post

    Re: Access 97/2000 (in)compatibility

    Judy: Thanks for that tip! We'll try your suggestion when we get back next week.

Posting Permissions

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