473,574 Members | 2,289 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 "Unrecogniz ed 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 2879
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.C ollatingOrder)

The "Unrecogniz ed 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.c o.uk> wrote in message
news:76******** *************** ***@posting.goo gle.com...
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 "Unrecogniz ed 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.Colla tingOrder 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.microsof t.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.C ollatingOrder)

The "Unrecogniz ed 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.c o.uk> wrote in message
news:76******** *************** ***@posting.goo gle.com...
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 "Unrecogniz ed 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.c o.uk> wrote in message
news:76******** *************** ***@posting.goo gle.com...
Hi Michael,

The XP box has locale 409 (English-US), whilst the Windows 2000
machine has locale 809 (English-UK). CurrentDb.Colla tingOrder 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.microsof t.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.C ollatingOrder)

The "Unrecogniz ed 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.c o.uk> wrote in message
news:76******** *************** ***@posting.goo gle.com...
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 "Unrecogniz ed 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
5139
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 characters. The entry of the field is "???" instead of the Japanese character. I tried to store the character with my java application and with the MySQL...
8
10491
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 are translated by the browser, but not in the alert.
3
1940
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 some strange reason, every once in a while the data changes to Japanese characters, it only happens once in a while, but once it happens that record...
11
6576
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 where the job is running, the job runs sucessfully, PDF files got generated, everything is good. If I scheduled the job to run at the time that I am...
11
4738
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 in japanese. But I am unable to display them back to GUI. It displays some junk characters Can anyone suggest me some way how to debug the issue. ...
4
2244
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: Korean, Japanese, and Chinese. Can anyone with experience in this area tell me of any special considerations? Access 2003. I've read here that the...
1
3769
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 marks when the data is Japanese). I can get Japanese to display when the text is static, i.e., embedded in the html, but have been unable to display it...
0
1941
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 which has English column names only. The DB2 Load Utility could not understand a table that has column names in Japanese. We tried loading data...
1
6511
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. Currently I am doing this DateTime dat = DateTime.Now;
0
7746
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8092
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
8262
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7842
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
6497
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5641
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3785
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1364
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1092
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.