RE2: message: the field is too small -Access form won't open

Tech-Archive recommends: Fix windows errors by optimizing your registry



Thanks Jerry for your great advice. I had to go back several backups but I
did find one that worked. Thank goodness that I had numerous backups. Now I
just have to figure out what data I am missing and re-enter it. I would love
to know what caused this corruption so it won't happen again. Is the
corruption something internal or is it caused from the internet?

"Jerry Whittle" wrote:

Sounds like a corruption issue that's been around since before your last
backup. Do you have an older backup?

It's possible that there is some code running behind the form that is
causing problems.

If you wish, zip up a copy of the database and send it to OCLV at
hotmail.com and I'll take a look at it.
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"mainlyblues" wrote:

I am using Access 2000 and have just received the error message (when trying
to open a form) "The field is too small to accept the amount of data you
attempted to add". I can not open my form but the table will open. How do I
solve this problem?
I tried using the repair office but this still did not work. I also got a
message "currently locked by another session on this machine". I also notice
and a pop up box at bottom of screen that read changing field data types but
it did not complete. It hung up about 75%. I tried using a backup but the
same thing happened. I even tried another computer but still did not work.
Any help would be greatly appreciated, thanks!
.



Relevant Pages

  • RE: SBSMonitoring Problem
    ... Thanks Jerry for the lengthy and most complete explanation. ... troubleshoot this today. ... My guess is the backup failed ... When you are prompted about whether you want to remove Microsoft SQL ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Exchange Backups...
    ... hi jerry, ... and results in "failure to mount media" errors in the backup log for any ... > A Volume Shadow Copy Service update package is available for Windows ... > Backing Up and Restoring Windows Small Business Server 2003 ...
    (microsoft.public.windows.server.sbs)
  • Jerry M. on The Fan; Strange Interview with Mike F.
    ... He tells Mike that there will be a lot of new faces among the backup ... Will the new guys play fundamentally sound baseball, as Jerry said ... position players. ...
    (alt.sports.baseball.ny-mets)
  • Re: word and excel wont open!
    ... Michael Solomon MS-MVP ... Backup is a PC User's Best Friend ... "jerry" wrote in message ...
    (microsoft.public.windowsxp.basics)
  • Re: [SLE] recovering deleted files
    ... to avoid this in future..... ... Jerry ... >> Is there a way to recover a directory that was accidentally deleted. ... >> contained months of research, and no, there was no backup of it. ...
    (SuSE)