Overflow Error Message

[NEWER USER]

I closed a form and all was OK. I reopened the form hours later and got a
message stating Overflow. The for will no longer open in Form or Design View.
Any ideas on WHY this can happen or HOW to open and repair.

 

[Arvin Meyer MVP]

I closed a form and all was OK. I reopened the form hours later and got a
message stating Overflow. The for will no longer open in Form or Design
View.
Any ideas on WHY this can happen or HOW to open and repair.

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Decompile your database:
http://www.trigeminal.com/usenet/usenet004.asp

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Maurice]

Overflow can also be caused by the passing the values set by the datatypes.
For instance if the integer value reaches above 32600+ records. In that case
set the type to long integer.