I hope someone out there can solve my mysterious problem. I have
tried everything imaginable, even paid $35 to Microsoft to help me,
but they were not able to figure out this problem: Here is the
problem:
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?
Anyone help would be greatly appreciated....
Mitchell, 3 1716 mi******@boh.co m (Mitchell Thomas) wrote:
A more meaningful subject would help a lot with getting meaningful answers. Such as
Japanese characters in record occasionally. I hope someone out there can solve my mysterious problem. I have tried everything imaginable, even paid $35 to Microsoft to help me, but they were not able to figure out this problem:
Eh? I would've thought MS would charge a lot more.
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?
This happens to only one record at a time then? Is it the entire record? Or just
one field in the record? Is it a memo field? When you say Japanese characters do
you mean it's just all kinds of scrambled characters of some sort or what really
looks like Oriental characters? What version of Access? Is this only on new data or
records that have been in the database for a while? Were they just updated?
Assuming you can somehow know this.
What happens when you move to that record? Does Access puke and die? Any strange
messages?
Above said I would suspect some corruption. And that the something is scrambling the
packets going down the wire. Does your building have flaky power? Have you tried
replacing your network hub/switch? Do you have older PCs? I wonder if one of them
has a slightly flaky network card or bad driver.
For other possible causes see the Access Corruption Causes page at my website.
However I rather doubt that OpLocks is causing this problem. It's something
intermittently flaky which can be very hard to track down.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony Toews <tt****@teluspl anet.net> wrote in message news:<0i******* *************** **********@4ax. com>... mi******@boh.co m (Mitchell Thomas) wrote:
A more meaningful subject would help a lot with getting meaningful answers. Such as Japanese characters in record occasionally.
I hope someone out there can solve my mysterious problem. I have tried everything imaginable, even paid $35 to Microsoft to help me, but they were not able to figure out this problem:
Eh? I would've thought MS would charge a lot more.
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?
This happens to only one record at a time then? Is it the entire record? Or just one field in the record? Is it a memo field? When you say Japanese characters do you mean it's just all kinds of scrambled characters of some sort or what really looks like Oriental characters? What version of Access? Is this only on new data or records that have been in the database for a while? Were they just updated? Assuming you can somehow know this.
What happens when you move to that record? Does Access puke and die? Any strange messages?
Above said I would suspect some corruption. And that the something is scrambling the packets going down the wire. Does your building have flaky power? Have you tried replacing your network hub/switch? Do you have older PCs? I wonder if one of them has a slightly flaky network card or bad driver.
For other possible causes see the Access Corruption Causes page at my website. However I rather doubt that OpLocks is causing this problem. It's something intermittently flaky which can be very hard to track down.
Tony
thankx for you repsonse. It only happens to one record at a time, and
it happens to several fields, no consistent pattern when it happens,
it only happens on updates. And yes it is either japanese or chinese
characters, not sure which one, that is what is the most puzzling
thing. running this on access 2002, and it has happened to old
records that were imported from access 97 and new records added in the
access 2002 database. When i move to that record i see the record in
the table, but sometimes it tells me it cannot find the reocrd. It is
a very strange problem. We have not had this problem on any other
access databases, its only this database. Thankx for any help in
advance. mi******@boh.co m (Mitchell Thomas) wrote: It only happens to one record at a time, and it happens to several fields, no consistent pattern when it happens, it only happens on updates. And yes it is either japanese or chinese characters, not sure which one, that is what is the most puzzling thing. running this on access 2002, and it has happened to old records that were imported from access 97 and new records added in the access 2002 database. When i move to that record i see the record in the table, but sometimes it tells me it cannot find the reocrd.
Is that the exact text of the error message? Could it be ""Search Key Was Not Found
in Any Record" or
This is really sounding like some network packets got scrambled in transit. IE
corruption.
This could also be one system having a different version of Jet than the others or
not all the Access patches.
What I've done is use the various API calls available and am checking the version
number and date/time of a crucial dll, msjetxx.dll, to ensure it matches what I have
on my system. See the tips page at my website for more details including sample
code: Verify Appropriate Jet Service Pack is installed www.granite.ab.ca\access\verifyjetsp.htm
It is a very strange problem. We have not had this problem on any other access databases, its only this database.
Ah, interesting. Is there anything unique about the computers who use that
databases? One which uses only that database and no other?
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: clintonG |
last post by:
Is there a document that explains the difference between the
Visual Studio .NET 2003 Combined Help Collection and the
MSDN Library for Visual Studio .NET 2003 or does someone
have comments describing the benefits of either or the other?
--
<%= Clinton Gallagher, "Twice the Results -- Half the Cost"
Architectural & e-Business Consulting -- Software Development
NET csgallagher@REMOVETHISTEXTmetromilwaukee.com
|
by: Larry Fix |
last post by:
I recently added help to a C# application using the Help.ShowHelp
method. My compiled help file gets display so that's good.
What's not so good is that the help window always starts out with a
very small size. Smaller than any page that's going to be displayed.
It's a real pain.
ShowHelp does not let you set the size. I can't find anyway to get a
hold of the help window after it's created so I can't hit it with the
resize hammer.
|
by: Tom marsh |
last post by:
I'm finishing an application and want to supply help files. However MS
Access's help files, ironically don't contain much help on HELP. What is
the best approach? I could easily just provide .doc files and shell out to
Wordpad.exe, but is there a better way? I'm using Access 2002. Any help is
appreciated.
|
by: deko |
last post by:
What's the best way to create a help system for Access 2003? Is MS HTML
Help Workshop the way to go? I want to put a clickable control on different
forms, that, when clicked, will bring up the help topic specific to that
form. Can this be done?
|
by: Junkguy |
last post by:
Hi,
I need help adding help to my Visual Studio 6 C# form application.
In searching around the Microsoft C# documentation for Visual Studio, I cannot
seem to discover how to add a menu item to bring up the Help Viewer within my
Windows Forms product. Everything there seems to deal only with the
HelpProvider tool. I don't want to use the HelpProvider, I simply want to open
the Table Of Contents in my application from a menu item for a...
| |
by: Rich Noons |
last post by:
Hi,
I'm currently trying to link a help file to an application. Everything is
linking correctly to the help topics (on the right hand side of the help
file). My problem is that the help contents on the left does not synchronise
to the topic displayed on the right hand side. (eg the tree structure opens)
and displays the associated topic. I've done this before with Win32 apps...
I'm using
|
by: JJ |
last post by:
Ok I have now got to grips with HTML help workshop and created my help
files, TOC etc.
Now how do I integrate this with my application? I have added an
errorprovider to my form and pointed it to my hhp file, but I am not sure
which is the correct next step.
Specifically my questions are:
1. How do I get the index, table of contents menu items to link to the help
file
|
by: WhiteWizard |
last post by:
Hello all,
I have been tasked with coming up with a system for providing help for our
users, and we have some somewhat unique requirements. NO INTERNET. This is
a windows application that will be running a good majority of the time at
about 60,000 feet.
I have done some previous work with and been reading about the "old" .chm
compiled html files and am leaning that way, but thought I would ask this
group what they thought, what...
|
by: TJ WIlson |
last post by:
Using Windows XP, my Access 2002 program works, but there are no help files. The help window opens, there is nothing there. I've tried repairing the installation, removing the installation and re-installing. Nothing works. I really need this to work, I've even tried the new downloads for help from MS, but it didn't help.
|
by: =?Utf-8?B?cnViZW4=?= |
last post by:
Hi developers,
Maybe this will sound silly, but I need help placing an icon in a menu when
setup is build in .Net through a setup project.
Really what I need is indicate the help icon (html help workshop file), I
couldn't find other way than copy the icon in the application folder and I
know HAVE TO BE another way to do it.
Please, I'll appreciate any help, Thanks.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
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.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
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 captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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 instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |