Append Query

[CharlesCount via AccessMonster.com]

When I run an append query it works for one time. Then I delete the
information and run the query and I get an numeric over run error, I expanded
all of the text fields to 255 and the numeric to long interger and still is
not working. If I delete a field at time to determine which one is not vaild
it will work one time and then I get the same error.
Is there a simple solution? the information being appended is taken from a
linked xls file.

Thanks

Charles

 

[Guest]

First try a compact and repair.

Next change the number fields to Double instead of long interger.

Any date fields? It's possible that something might be going in with a data
bigger or smaller than Access can handle.

 

[CharlesCount via AccessMonster.com]

Thanks
Compact and repair works but the error returns after the next reset and that
would mean that I have to run compact and repair every time I append new or
replace the data.
Is that normal?
Can I add a macro to run the compact and repair, I would added just before
the append command.

Charles

First try a compact and repair.

Next change the number fields to Double instead of long interger.

Any date fields? It's possible that something might be going in with a data
bigger or smaller than Access can handle.

When I run an append query it works for one time. Then I delete the
information and run the query and I get an numeric over run error, I expanded

[quoted text clipped - 7 lines]

Charles

 

[CharlesCount via AccessMonster.com]

Thanks
Compact and repair works but the error returns after the next reset and that
would mean that I have to run compact and repair every time I append new or
replace the data.
Is that normal?
Can I add a macro to run the compact and repair, I would added just before
the append command.

Charles

First try a compact and repair.

Next change the number fields to Double instead of long interger.

Any date fields? It's possible that something might be going in with a data
bigger or smaller than Access can handle.

When I run an append query it works for one time. Then I delete the
information and run the query and I get an numeric over run error, I expanded

[quoted text clipped - 7 lines]

Charles

 

[Guest]

That is not normal which means the database has a serious corruption problem.

Tony Toews has an excellent web page on database corruption.
http://www.granite.ab.ca/access/corruptmdbs.htm

Allen Brown also has excellent info on corruption.
http://allenbrowne.com/ser-47.html

I have a white paper in a Word document named Fix Corrupt Access Database
towards the bottom this page:
http://www.rogersaccesslibrary.com/OtherLibraries.asp

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

Thanks
Compact and repair works but the error returns after the next reset and that
would mean that I have to run compact and repair every time I append new or
replace the data.
Is that normal?
Can I add a macro to run the compact and repair, I would added just before
the append command.

Charles

First try a compact and repair.

Next change the number fields to Double instead of long interger.

Any date fields? It's possible that something might be going in with a data
bigger or smaller than Access can handle.

When I run an append query it works for one time. Then I delete the
information and run the query and I get an numeric over run error, I expanded

[quoted text clipped - 7 lines]

Charles