Data no longer visible in tables

[mtj8617]

I am using an application that uses an Access database, and I believe the original database was created in the 97 version. The application queries the database and allows a person to view the data in the database to select a particular instrument to test. When the MS Office was upgraded by our IT we are no longer able to view the data in application. The fields, rows, and columns appear, but the numbers and letters are not visible. The data is really there, but can't be seen.

I have attached a screenshot of the view that shows the white columns and rows.



If you have any suggestions, please be as specific as possible, because I am not very familiar with Access when it comes to running VB scripts and such to make changes to settings.

[June7]

Try creating a new Access 2003 file and importing the data. Can the app now see data?

[mtj8617]

Data is still in the database, but you just can't see it. The rows and columns show up as white spaces in the application. If I open the database up in Access I can see the data there. I tried the export and import tool in the application, and it exports to Excel okay, but it will not import the data from the Excel spreadsheet at all.

[Rawb]

Was the database updated to Access 2003? Or are you just using Access 2003 to view an Access 97 database?

If the database file itself was updated, then that's likely your problem. Try converting the database back to Access 97 and see if that solves the issue (Note: Backup your database before you convert it!)

If the file wasn't updated, then the problem could be that you JetDirect version changed wien you installed Access 2003 (JetDirect is the protocol used to "read" an access database directly) or it could be an ODBC issue.

I'd check the application's documentation to see how it connects to the database: If it uses JetDirect, then you will likely have to reinstall Access 97. If it uses ODBC, you can probably just load the appropriate ODBC drivers on your computer.

[mtj8617]

The application uses ODBC drivers and not JetDirect. How do I load the older version ODBC drivers. I believe I need version 12.00.6606.1000 of the Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx), Microsoft Access Driver (*.mdb,*.accdb), Microsoft AccessParadox Driver (*.db), and Microsoft Access Text Driver (*.txt, *.csv). Any ideas of how to obtain these drivers and load them onto my computer?