471,601 Members | 1,203 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,601 software developers and data experts.

Using a Japanese Access '97 database under Windows XP

Hi,

Currently I am working on a Visual Basic program that makes use of an
Access database produced under Japanese Access '97.

The program works correctly on Windows 2000, however when it is used
under English XP, Visual Basic reports the error "Could not find file"
when it tries to open the database.

I have tried converting the database to Access 2000, however this now
gives the error "Unrecognized database format" on our Windows XP test
machine.

Why does this VB program work ok under windows 2000, but not under XP?
What can I do to fix it?

The original installation I was given didn't install MDAC, but adding
in MDAC 2.7 doesn't alter the symptoms.

Chris Williamson
Nov 13 '05 #1
3 2760
Can you provide more info, such as the following?

1) Default System Locale for the 2000 and XP boxes
2) Default User Locale for the 2000 and XP boxes
3) Collation of the database Hex(CurrentDb.CollatingOrder)

The "Unrecognized database format" is expected with an attempt to open a Jet
4.0 format MDB file with Jet 3.5.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Chris Williamson" <ca*******************@yahoo.co.uk> wrote in message
news:76**************************@posting.google.c om...
Hi,

Currently I am working on a Visual Basic program that makes use of an
Access database produced under Japanese Access '97.

The program works correctly on Windows 2000, however when it is used
under English XP, Visual Basic reports the error "Could not find file"
when it tries to open the database.

I have tried converting the database to Access 2000, however this now
gives the error "Unrecognized database format" on our Windows XP test
machine.

Why does this VB program work ok under windows 2000, but not under XP?
What can I do to fix it?

The original installation I was given didn't install MDAC, but adding
in MDAC 2.7 doesn't alter the symptoms.

Chris Williamson

Nov 13 '05 #2
Hi Michael,

The XP box has locale 409 (English-US), whilst the Windows 2000
machine has locale 809 (English-UK). CurrentDb.CollatingOrder is Hex
411.

Additionally, we've now found that the database opens correctly if
Japanese language support is installed on XP (the Windows 2000 machine
already had this, so it appears that the OS type may not be
significant).

Obviously it's not ideal to ask all our users to install Japanese
support. Is there any simple way to convert a Japanese Access '97
database into a database that uses only Western fonts?

Chris Williamson

"Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in message news:<40********@news.microsoft.com>...
Can you provide more info, such as the following?

1) Default System Locale for the 2000 and XP boxes
2) Default User Locale for the 2000 and XP boxes
3) Collation of the database Hex(CurrentDb.CollatingOrder)

The "Unrecognized database format" is expected with an attempt to open a Jet
4.0 format MDB file with Jet 3.5.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Chris Williamson" <ca*******************@yahoo.co.uk> wrote in message
news:76**************************@posting.google.c om...
Hi,

Currently I am working on a Visual Basic program that makes use of an
Access database produced under Japanese Access '97.

The program works correctly on Windows 2000, however when it is used
under English XP, Visual Basic reports the error "Could not find file"
when it tries to open the database.

I have tried converting the database to Access 2000, however this now
gives the error "Unrecognized database format" on our Windows XP test
machine.

Why does this VB program work ok under windows 2000, but not under XP?
What can I do to fix it?

The original installation I was given didn't install MDAC, but adding
in MDAC 2.7 doesn't alter the symptoms.

Chris Williamson

Nov 13 '05 #3
Well, conversion will corrupt the data, so you might have to explain how you
wanted to convert it. The best way is to update to Jet 4.0 which uses
Unicode and which does not use the OS data tables (and which therefore does
not require anything specific to be installed).
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

"Chris Williamson" <ca*******************@yahoo.co.uk> wrote in message
news:76**************************@posting.google.c om...
Hi Michael,

The XP box has locale 409 (English-US), whilst the Windows 2000
machine has locale 809 (English-UK). CurrentDb.CollatingOrder is Hex
411.

Additionally, we've now found that the database opens correctly if
Japanese language support is installed on XP (the Windows 2000 machine
already had this, so it appears that the OS type may not be
significant).

Obviously it's not ideal to ask all our users to install Japanese
support. Is there any simple way to convert a Japanese Access '97
database into a database that uses only Western fonts?

Chris Williamson

"Michael \(michka\) Kaplan [MS]" <mi*****@online.microsoft.com> wrote in

message news:<40********@news.microsoft.com>...
Can you provide more info, such as the following?

1) Default System Locale for the 2000 and XP boxes
2) Default User Locale for the 2000 and XP boxes
3) Collation of the database Hex(CurrentDb.CollatingOrder)

The "Unrecognized database format" is expected with an attempt to open a Jet 4.0 format MDB file with Jet 3.5.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Chris Williamson" <ca*******************@yahoo.co.uk> wrote in message
news:76**************************@posting.google.c om...
Hi,

Currently I am working on a Visual Basic program that makes use of an
Access database produced under Japanese Access '97.

The program works correctly on Windows 2000, however when it is used
under English XP, Visual Basic reports the error "Could not find file"
when it tries to open the database.

I have tried converting the database to Access 2000, however this now
gives the error "Unrecognized database format" on our Windows XP test
machine.

Why does this VB program work ok under windows 2000, but not under XP?
What can I do to fix it?

The original installation I was given didn't install MDAC, but adding
in MDAC 2.7 doesn't alter the symptoms.

Chris Williamson

Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Keitaro | last post: by
8 posts views Thread by Daniel | last post: by
3 posts views Thread by Mitchell Thomas | last post: by
1 post views Thread by schouwla | last post: by
reply views Thread by CCCYYYY | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.