A few more A97 vs A2000 questions

[Alp Bekisoglu]

Hi Experts,

The first question I have is: is there an add-on/utility or such for A2K to
create the so named "switchboard" form's code in an A97 compatible way?

Second is the fact that I am facing character display problems between
machines and can't resolve the problem so far. One set of machines are W98
SE and use A97 the others include XP, W2K with a variety of Access versions
except A97.

The back-end is becoming problemmatic due to this character problem. Data
entered is in Turkish on all machines but there is this incompatibility
between the first set and the rest. Any help would be highly appreciated.

Thanks in advance.

Alp

 

[Douglas J. Steele]

The Switchboard Manager has moved from the Add-ins section to under Tools |
Database Utilities.

Access 97 doesn't support Unicode, so I'm not sure that it's appropriate for
Turkish. Don't think you have much choice but to upgrade everyone to at
least Access 2000.

 

[Alp Bekisoglu]

Hi Douglas,

Thanks for the info. Regarding the switchboard question, I was trying to
find out "if" in A2K I could be able to create a form which would be
compatible with A97, i.e.: one that I should not be forced to alter things
related to CurrentDatabase -> CurrentDb, or the like. A2K also indicates
ADODB within the code which I do not want. A SwB created in A97 has no
problems compiling in A2K but changes to the code must be made in reverse.

Alp

 

[Brendan Reynolds]

If you want to develop apps that will work in both Access 97 and later
versions, I would strongly advise developing in Access 97 and converting to
the later version before deployment, rather than developing in the later
version and converting to Access 97.

 

[Alp Bekisoglu]

Thanks Brendan,

Point taken.

Alp

If you want to develop apps that will work in both Access 97 and later
versions, I would strongly advise developing in Access 97 and converting
to the later version before deployment, rather than developing in the
later version and converting to Access 97.

 

[Douglas J. Steele]

Brendan's advice is sound. However, I just thought I'd point out that you
can still use DAO in Access 2000.

With any code module open, select Tools | References from the menu bar,
scroll through the list of available references until you find the one for
Microsoft DAO 3.6 Object Library, and select it. Assuming you're not going
to be using ADO, uncheck the reference to Microsoft ActiveX Data Objects 2.1
Library