D
DB_Newbie2007
I appear to be having a problem with an append query. I created a select
query, converted the query to a make table query. The query created the
table, NewTable, and inserted the data.
I then modified the query again to an append query. The data in NewTable was
deleted, then I ran the append query... everything ran fine.
I opened NewTable in Design View, saved the table (NO changes were made). I
re-ran the append query and it failed:
Microsoft Access can't append all the records in the append query.
Microsoft Access set 0 field(s) to Null due to a type conversion failure,
and it didn't add 0 record(s) to the table due to key violations, 0 record(s)
due to validation rule violations....
I was trying to modify the table to add an index, but if the query fails
just for opening the table in design view and saving it, then the append
query fails, it is kind of difficult to add the index!
The only thing I can think if is Design View must be modifying the table
somehow? Putting some data fields into a mode other than what they were
before the Save?
Unfortunately, an upgrade to a newer version of MS Access is not possible,
as this version works with an application that requires MS Access 2000.
Any suggestions? Has anyone else experienced the same problem?
query, converted the query to a make table query. The query created the
table, NewTable, and inserted the data.
I then modified the query again to an append query. The data in NewTable was
deleted, then I ran the append query... everything ran fine.
I opened NewTable in Design View, saved the table (NO changes were made). I
re-ran the append query and it failed:
Microsoft Access can't append all the records in the append query.
Microsoft Access set 0 field(s) to Null due to a type conversion failure,
and it didn't add 0 record(s) to the table due to key violations, 0 record(s)
due to validation rule violations....
I was trying to modify the table to add an index, but if the query fails
just for opening the table in design view and saving it, then the append
query fails, it is kind of difficult to add the index!
The only thing I can think if is Design View must be modifying the table
somehow? Putting some data fields into a mode other than what they were
before the Save?
Unfortunately, an upgrade to a newer version of MS Access is not possible,
as this version works with an application that requires MS Access 2000.
Any suggestions? Has anyone else experienced the same problem?