Resolve Error regarding missing object dependency

[isladogs]

Why would you do this?


Copy the table structure & its data to the new table. No need for an append query

[drunyan0824]

Why would you do this?
Copy the table structure & its data to the new table. No need for an append query

Two reason. First I am pretty new to access so I am still trying to learn and figure out how access operates and how to create databases in general. So part of my reasoning was to learn how to do an append query and figure out where it could be used. Second, My understanding of how copy and paste work I would think that if there was a problem with the dependencies between tables in my database, that copying and pasting the tables would also duplicate the dependence issues between the tables. As I understand it, the append query takes just the data from one table and inserts the data into another table. I know that using an append query is probably over complicating the process, but it seems like using the append query would prevent the duplication of any dependences between tables.

Like I said, I am new to access and am probably wrong on how to do most things in access.

[Micron]

Could I create a new table called tblCableCategory that has the same structure as tblCategory and then run an append query to copy all of my data from tblCategory to tblCategory and avoid a dependence error?

You could end up with records with different pk (autonumbers) than what you had before, making the problem far worse if there are records in other tables with related data that was tied to the old an's.

Seems to me that introducing dependency failures won't be fixed by copying tables IF the dependency is in a query (including calculated query fields), control rowsource, calculated control, etc. because those things are "down stream" so to speak. They are looking for something that doesn't exist. I don't develop much anymore but when I was, sometimes I'd change something if it helped me or anyone continue with design but I'd use the documenter, export the output to Word then use Find to look for the old name. You pretty much have to output everything though.

[isladogs]

As already stated, doing this with an append query is unnecessary for this purpose and, as Micron has explained, it may also cause problems as it is likely that autonumber values will not all be the same.
There will be plenty of opportunities to learn about the different types of query such as INSERT (append) for other purposes.