Windows Forum

Ask something
Discussion Locked

Converting Access Databases

0 helpful
6 replies

by kevin holden

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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?

6 replies

by philip

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?

by rraheb

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.

by smokeybear

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!

by kevin holden

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.

This discussion is closed to new replies.