473,322 Members | 1,409 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,322 software developers and data experts.

Access 97 to XP Access Conversion Error

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 is
lost. i have tried everything compacting, importing to a new
database, new table...What is causing this strange behavior?
Nov 12 '05 #1
1 1454
Mitchell Thomas wrote:
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 is
lost. i have tried everything compacting, importing to a new
database, new table...What is causing this strange behavior?


Is it possible someone is changing the character set in your office?

Joe Fallon wrote back in 1999
I was installing some new stuff and came across an interesting pprogram
that MS stuck in my
Start/Programs/MS Office Tools area. (Who ever looks there??)
Anyway, it is called MS Office Language Settings.
I ran it for kicks and it asks what other language you would like to
support.
Cyrillic is listed 3 times.
Perhaps if you selected this option and THEN converted an mdb you would be
OK.

You might want to check http://groups.google.com, advanced search, group
*access* and look for Character set change convert as some of the words.
Nov 12 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: gary.scott | last post by:
Aaaaaarrgghh ! (that's better) I am trying to convert a field within my Oracle 9i Database that is of type BLOB (but this BLOB may contain a combination of clobs/varchars or images such as gif...
20
by: John | last post by:
Hi, I've recently upgraded from Access 97 to Access 2002 & the performance basically stinks. I have tried the following items listed below but it has only had a minor impact: 1) Upgraded Jet...
2
by: Maurice | last post by:
Folks once again I look forward to your invaluable assistance. When converting an Access 2002 mdb back to Access 1997 using the Access 2002 inbuilt tools I receive the following error message...
5
by: Lakbir Dhillon | last post by:
We converted our databases from Access 97 to Access 2002 (only the MDB files, not the MDW file). In addition we ported the Access application from a Citrix NT server to a Citrix XP server. We...
5
by: John Furphy | last post by:
Please excuse my ignorance in this area, being an amateur Access user. I have an Access 2000 application which runs fine, however when I convert it to Access 2002 and run it, it comes up with...
0
by: Jim M | last post by:
For about a year and a half now I have been working in Access 2002 at home and converting to Access 2000 for work (I need both versions). I made a few changes to forms and queries then converted to...
1
by: lorirobn | last post by:
Hello, I created an Access database in Access 2002-2003 that I am trying to convert to Access 2000. During conversion, I get error "The report name ' dirDataCopy' you entered in either the...
11
by: Steve Gough | last post by:
Could anyone please help me to understand what is happening here? The commented line produces an error, which is what I expected given that there is no conversion defined from type double to type...
3
by: Roy Tong | last post by:
I maintain a shared database on Access 97. I've just tried converting a test copy of the database to 2003 and it appeared to work OK. That is I got no error messages. However then I look at my...
3
by: prakashwadhwani | last post by:
I have just been asked to port an Access 97 app from an old Pentium 3 to a new Pentium Core-2-Duo PC. On the new PC, Office 2003 is installed. On opening the database, Access provided me with an...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
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...
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: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
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: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.