General discussion

  • Creator
    Topic
  • #2073847

    Converting Access Databases

    Locked

    by kevin holden ·

    I have been working on a database in Access 2000 and need to run it on an Access 97 computer. When I convert the database to 97, some (not all) of the calculation fields in a querry loose formating and I cannot change them back. The Access 97 system thinks they are text for formatting, whoever they do the math. It is very important that the numbers diplay correctly (percent with no decimal places). Any suggestions short of rewritting the database?

All Comments

  • Author
    Replies
    • #3784975

      Converting Access Databases

      by philip ·

      In reply to Converting Access Databases

      I’m not sure…
      Why not try this: Import the database into Excel 2000, then convert it to the Excel 97 format, then import it into Access 97. I hope this will work.

      Or, if you want – install Access 2000 on the destination computer. There will beno problems with the displaying the the data 🙂

      OK, does the suggestion with the multi-converting work?

      • #3766793

        Converting Access Databases

        by kevin holden ·

        In reply to Converting Access Databases

        Question is about a problem with a query and you cannot export queries. Thanks for the try.

    • #3783067

      Converting Access Databases

      by rraheb ·

      In reply to Converting Access Databases

      OK, Try doing the following:

      On your access 97 PC open the database that has the incorrect query fields, delete the queries which are causing the problem.

      Then in the Tools->Options choose the “Tables/Queries” tab and change the default filed type to “Number”.

      After doing this, try to import the queries which are causing the problem one more time. Or try to export them from the Access 2000 databse directly to the new access 97 databse.

      Hope this helps you out.

      Best Regards,

      Rafik El-Raheb.

    • #3784370

      Converting Access Databases

      by smokeybear ·

      In reply to Converting Access Databases

      Do this and I gurantee that your querry will work!

      First, each querry you have created in Access has a SQL view equvalant. The reality is that when you created a querry in Access, it is generating SQL statements behind those preety querry views.

      Highlight on the querry you wish to view and click on DESIGN, then under VIEW MENU click on SQL VIEW. You should see a bunch of SQL statements.

      Now copy those to a text file, save this text file, transfer it to the PC with Access 97. Also save the tables created in Access 2000 to Access 97 and transfer it to the pc with Access 97, assuming that you do not have this tables ready in the pc with Access 97.

      Now open up the database in Access 97, then go to design a querry view, create a new querry, with whatever tables you wish to querry upon. Then go the SQL view and paste the SQL statements you have saved previously.

      The querry should work!

      • #3766795

        Converting Access Databases

        by kevin holden ·

        In reply to Converting Access Databases

        No it did not work with this one. I think how ever that the problem was that the formula was too complex for Access 97 to handle and format. It is strange because it did the math just not the formatting.

Viewing 2 reply threads