I'm trying to copy a backend table which has had a pivot table defined on it
to the front end with a new name, but retaining the pivot table definition.
I can't seem to do this without it ending up in the front end as linked to
the backend. I'm using docmd.copyobject to do this.

How do I make this happen?

Thanks,

Kevin

Got it to work, but to be honest, I'm not sure how, or what I started doing
differently. Did discover that doing a copyobject of a table with a pivot
defined from the front end to the back end worked, but while a link to that
new table on the backend (after deleting it from the front end) did not work,
copying it back to the front end with a new name did work.

"Kevin Witty" wrote:

> I'm trying to copy a backend table which has had a pivot table defined on it
> to the front end with a new name, but retaining the pivot table definition.
> I can't seem to do this without it ending up in the front end as linked to
> the backend. I'm using docmd.copyobject to do this.
>
> How do I make this happen?
>
> Thanks,
>
> Kevin