Append Query Access 2007

[sportsguy]

Converted FE and BE to Access 2007 from 2003.

Append query won't append to BE table as it did in 2003,
error message unable to append all due to key violations.

BUT i can copy and paste the output into the BE table from the FE database. . .

what am i missing here????

thanks in advance

sportsguy

 

[GinaWhipp]

Is your database in a Trusted Location? See Trusted Locations

 

[sportsguy]

Hi Gina,

yeppers. . . all my databases are in trusted locations. . .

the error must be some sort of corruption issue during conversion,
but I compact and repair all FE databases on close. . .

have any other suggestions??

thanks in advance

sportsguy

 

[GinaWhipp]

Okay, well that Compact on Close will cause corruption so turn that off. Next thing to check is folder permissions. Make sure everyone has Read/Write/Delete, in essence, full permissions.