473,320 Members | 1,926 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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 2853
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Keitaro | last post by:
Hi, I am developing a vocabulary trainer. The languages I want to support are German and Japanese. When I try to store Japanese characters in my mysql database, I do not get the correct...
8
by: Daniel | last post by:
I'm trying to make a site work for japanese characters. It works fine except for the alerts in javascript. The characters are stored in unicode, as this; 'コミック全巻配' Those unicode characters...
3
by: Mitchell Thomas | last post by:
I recently created a new database in Access 2002. I took data from an access 97 database converted one of the tables to access 2002 and then imported it into a new table in access 2002. but for...
11
by: Grasshopper | last post by:
Hi, I am automating Access reports to PDF using PDF Writer 6.0. I've created a DTS package to run the reports and schedule a job to run this DTS package. If I PC Anywhere into the server on...
11
by: prats | last post by:
I want to write a GUI application in PYTHON using QT. This application is supposed to take in Japanese characters. I am using PyQt as the wrapper for using QT from python. I am able to take input...
4
by: wheel | last post by:
I have already built in support for multiple languages in some of my applications, but so far they have only used Western languages (English, Spanish, etc). I need to add some Far East languages:...
1
by: bjs | last post by:
I am using MS SQL Server 2000 and 2005, IIS 5,0 and ASP. I am able to display data that has been selected from a Unicode column in the database in all languages except Japanese (I get question...
0
by: abrahamvk | last post by:
Hi, How to load data into Japanese DB2 Database using DB2 Load Utility, where the table column names are in Japanese in windows environment. We could successfully load Japanese data into a table...
1
by: schouwla | last post by:
Hi, I want to create dates in the following format: dd-MMM-yyyy e.g. 13- Mar-2007 But are seeing some problems when running on a Japanese Windows XP. Regional settings are set to JP. ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.