Append Query

[Guest]

I have an append query that takes data from one table and pastes it into
another.
the Append query takes data from a table iwth 8 fields, and pastes it into a
table with about 40 fields. the 8 fields have exactly the same names in
both tables. they have the same validation rules. the same zero length
settings. the same format. the same everything you can show on that little
properties set using the f4 hotkey.
I have been told that i should ignore the warnings and simpmly turn them off
I would much rather find the cause for this problem in case it actually
starts rejecting records, now, rather than later.
someone, please, help.
I'll be happy to provide a copy of the database, or queries. whatever you
need.

 

[Guest]

Hey Pwyd:

Without knowing which error messages you are receiving it makes it hard to
tell you specifically what your difficulty is. However, I can think of a
few areas you might want to look at:

You say you are appending a table of 8 fields to a table of 40+? If you
have any validation rules, input masks or default settings in fields that are
NOT being updated, you may get errors for each of those fields. My
suggestion is that if you really do not like ignoring or turning off error
messages (I'm the same way!) then remove each of these options from the table
you are updating.

Date fields are, in my opinion, the worst contributors to error messages -
be certain ALL input masks for date fields are removed removed from your
target table - if not, you'll get an error message every time it tries to
update the field, even though the update usually works.

I generally create a basic, data-holding table that has no input masks,
validation rules, default settings or even required fields. I then create
what I refer to as a "work table" that uses all the restrictions I need, then
update the data in the "work table" to the base table. It's a bit more work
but it works very well in getting rid of those pesky error messages.

Turning them off will work, but, really, what fun is that?!

Good luck and God bless,

-TSC-