Converting Access XP switchboard to Access 97 (Application.Curren.

[MSLuci]

Need to convert an Access XP app to Access 97 format. I'm getting a compile
error on the Switchboard form with the following :

Application.CurrentProject.Connection

Can someone help with suggestions. I'm not familiar with '97 enough to know
the work around.
Thanks

 

[Norman Yuan]

Application.CurrentProject object is for Access *.ADP file type, which is
only introduced into Access from Access2K and does not exist in Access 97 or
earlier version. I do not think the conversion can go throuogh. You must
convert the form manually and revise code accordingly.

When you try convert newer version to older version, if a feature that does
not exist in older version, very likely, you end up rewrite/redesign your
app.

 

[Brendan Reynolds]

The switchboard manager in recent versions of Access uses features that
simply did not exist in Access 97. You may find it easier to delete the
switchboard table and form from the Access 97 MDB and recreate them using
the Access 97 switchboard manager.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.