Opening File in Office 97 vs 2000

[Moonman]

I have created a file in Office 97 and put it out on a server. Those in my group who have Office 97, have no problem accessing the file. Others that are running Office 2000 are unable to access the file. Access opens and the gives the option to open or convert the file. When the open option is selected and then nothing happens. I have also tried to convert to 2000 format, and still nothing happens.

 

[Pat Hartman]

The conversion process is sensitive to compile errors. Make sure that there are none in the A97 version. Also, if you use DAO, you will most likely end up with compile errors in A2K unless the DAO library is present in the list of references and has a higher priority than the ADO library.

To make the conversion a smooth as possible, modify the A97 version to specifically identify DAO objects. For example:

Dim myDB as DAO.Database
Dim myTbl as DAO.TableDef
Dim myRst as DAO.Recordset
etc.