1 reply to this topic

[williamevanl]

So I have a query that basically pulls an entire linked table (quality score) table into a new created table. (table2) The query works fine as long as the the table (table2) doesnt exist and I have recently saved (or opened) the query in the the access database. This by itself doesnt make sense. If I run it right now without table2 existing I get this error message: You cannot record your changes because a value you entered violates the settings defined for this table or list.

But... if I right mouse click query1 and select design view and then save it, the query runs fine immediately following this. (note I didn't actually change anything)

If I start everything fresh remove table2 and save query1 in design view it all works. I have a macro that opens the mdb file deletes table2 and then attempts to: select * from qualityscore into table2 which results in the error listed. Please help!!

[WingedPanther]

Does it delete the records from the table, or delete the table itself?