A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"garbage" record



 
 
Thread Tools Display Modes
  #1  
Old July 12th, 2004, 02:48 PM
TRM
external usenet poster
 
Posts: n/a
Default "garbage" record

I have had a problem with a record "turning into garbage"
so to speak. I have no idea what or how this happened,
this DB is on a server, but one day the users couldn't
access this specific record. The record now contains
only fragments of the original record; most of it
is "gibberish", what appears to be Chinese, or Japanese
letters.

Anyone ever have this happen before and what might be the
cause?!

THANKS!
  #2  
Old July 12th, 2004, 05:05 PM
Allen Browne
external usenet poster
 
Posts: n/a
Default "garbage" record

The symptoms indicate that the database is partially corrupted.

Delete the record, and then compact the database:
Tools | Database Utilities | Compact

If you cannot delete the record, this article describes various ways of
rebuilding the database:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"TRM" wrote in message
...
I have had a problem with a record "turning into garbage"
so to speak. I have no idea what or how this happened,
this DB is on a server, but one day the users couldn't
access this specific record. The record now contains
only fragments of the original record; most of it
is "gibberish", what appears to be Chinese, or Japanese
letters.

Anyone ever have this happen before and what might be the
cause?!

THANKS!



  #3  
Old July 27th, 2004, 07:30 AM
TRM
external usenet poster
 
Posts: n/a
Default "garbage" record

Thank you by the way! I did get this taken care of!
-----Original Message-----
The symptoms indicate that the database is partially

corrupted.

Delete the record, and then compact the database:
Tools | Database Utilities | Compact

If you cannot delete the record, this article describes

various ways of
rebuilding the database:
Recovering from Corruption
at:
http://allenbrowne.com/ser-47.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"TRM" wrote in

message
...
I have had a problem with a record "turning into

garbage"
so to speak. I have no idea what or how this happened,
this DB is on a server, but one day the users couldn't
access this specific record. The record now contains
only fragments of the original record; most of it
is "gibberish", what appears to be Chinese, or Japanese
letters.

Anyone ever have this happen before and what might be

the
cause?!

THANKS!



.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Button to print current record only Fatz Using Forms 6 June 17th, 2004 01:58 PM
Quirky Record Neil Ginsberg Setting Up & Running Reports 1 June 10th, 2004 01:08 AM
Form Doesn't Go To New Record Steve New Users 15 May 16th, 2004 04:33 PM
Form Does Not Go To New Record Steve New Users 1 May 12th, 2004 03:15 AM
Avoid Creating A Duplicate Record Mark New Users 4 May 11th, 2004 01:52 AM


All times are GMT +1. The time now is 12:58 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.