2003 to 97 conversion error message

[JayhawkJim]

My 2003 Access db works fine; tables, queries, forms, reports/charts,
switchboards. However, when I convert it to Access 97 for the tech deficient
folks at the office, I get an error message. After converting the 2003 db to
97, you are instructed to open the db in 97, open any module in design view
and then, “On the Debug menu, click ‘Compile And Save All Modules.’†CTRL-G
brings up the Debug Menu. When I follow those instructions, I get the
following error:

' Open the table of Switchboard Items, and find
' the first item for this Switchboard Page.
Set con = Application.CurrentProject.Connection

The entry <.CurrentProject.> is highlighted. What do I do? Any ideas out
there?

 

[Allen Browne]

From memory, CurrentProject was not part of Access 97. Whatever you were
seeking to achieve with the code that relies on this, you will have to
re-write that code.

The Connection probably relies on the ADO library which was not part of A97
by default.