Hi,
In Access I've linked an Excelsheet to the tables in Access. Through queries I update, append and delete records to ensure that the table has the latest data. When I execute the queries, I get several notifications. Some are of the kind that ask if I would like to proceed, some are a notification with violations, like: Key violations, lock violations and rule violations with the Append query. Is there some way to get the records from these violations exported to a table or Excelsheet so that I could look and see if which records has writing mistakes??? Thanks allready for your effort!
Greetings,
Maik
In Access I've linked an Excelsheet to the tables in Access. Through queries I update, append and delete records to ensure that the table has the latest data. When I execute the queries, I get several notifications. Some are of the kind that ask if I would like to proceed, some are a notification with violations, like: Key violations, lock violations and rule violations with the Append query. Is there some way to get the records from these violations exported to a table or Excelsheet so that I could look and see if which records has writing mistakes??? Thanks allready for your effort!
Greetings,
Maik
