By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
460,029 Members | 1,305 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 460,029 IT Pros & Developers. It's quick & easy.

Using a Japanese Access '97 database under Windows XP

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.