2003 to 97 conversion error

  • Thread starter Thread starter JayhawkJim
  • Start date Start date
J

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?
 
I'd be tempted to delete both the Switchboard form and Switchboard Items
table. Then rebuild the switchboard from scratch.
 
I don't think CurrentProject was introduce to Access until A2K. You might
be able to substitute CurrentDb, (just CurrentDb, not
Application.CurrentProject.Connection) for certain things, but I'm not sure
what you are trying to accomplish with this line.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
Back
Top