MS Access data conversion - A few more A97 vs A2000 questions

Author

A few more A97 vs A2000 questions

Alp Bekisoglu

2006-01-18, 7:24 am

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

2006-01-18, 8:25 pm

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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Alp Bekisoglu" <alp@access_ng.com> wrote in message
news:%23nbM4XBHGHA.2696@TK2MSFTNGP14.phx.gbl...
> 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
>
>

Alp Bekisoglu

2006-01-19, 7:24 am

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

"Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
news:O8pML7HHGHA.2444@TK2MSFTNGP11.phx.gbl...
> 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.
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Alp Bekisoglu" <alp@access_ng.com> wrote in message
> news:%23nbM4XBHGHA.2696@TK2MSFTNGP14.phx.gbl...
>
>

Brendan Reynolds

2006-01-19, 7:24 am

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.

--
Brendan Reynolds
Access MVP

"Alp Bekisoglu" <alp@access_ng.com> wrote in message
news:uLO64wNHGHA.3116@TK2MSFTNGP15.phx.gbl...
> 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
>
> "Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
> news:O8pML7HHGHA.2444@TK2MSFTNGP11.phx.gbl...
>
>

Alp Bekisoglu

2006-01-19, 9:24 am

Thanks Brendan,

Point taken. :-)

Alp

"Brendan Reynolds" < brenreyn@discussions
.microsoft.com> wrote in message
news:OYGJYiPHGHA.3200@tk2msftngp13.phx.gbl...
> 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.
>
> --
> Brendan Reynolds
> Access MVP
>
> "Alp Bekisoglu" <alp@access_ng.com> wrote in message
> news:uLO64wNHGHA.3116@TK2MSFTNGP15.phx.gbl...
>
>

Douglas J. Steele

2006-01-19, 8:25 pm

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

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"Alp Bekisoglu" <alp@access_ng.com> wrote in message
news:uLO64wNHGHA.3116@TK2MSFTNGP15.phx.gbl...
> 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
>
> "Douglas J. Steele" < NOSPAM_djsteele@NOSP
AM_canada.com> wrote in message
> news:O8pML7HHGHA.2444@TK2MSFTNGP11.phx.gbl...
>
>

Sponsored Links