Copy backend table to local WITH pivottable, WITHOUT getting it as

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top