2003 to 97 conversion error

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?
 
J

Jerry Whittle

I'd be tempted to delete both the Switchboard form and Switchboard Items
table. Then rebuild the switchboard from scratch.
 
R

Roger Carlson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top