ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Updating a database table (https://www.excelbanter.com/excel-programming/349390-updating-database-table.html)

Michael Malinsky

Updating a database table
 
I have an Excel spreadsheet that I am using to query and update an
Access database. I was receiving the following error:

"The record cannot be deleted or changed because table 'Table1'
includes related records."

I figured out that this occurred because a relationship existed between
Table1 and Table2. Once I deleted the relationship, the error
disappeared. I know (although I honestly cannot remember the technical
reason) that creating relationships are a good thing, it created a
problem for me here.

Maybe the best and easiest answer is for me to not worry about
relationships and leave it like it is since it works, but I wanted to
pick some other brains.

Thanks,
Mike.



All times are GMT +1. The time now is 05:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com