I have a split database. Before some complex operations I need to make temporary copies of two tables in the back-end as a backup in case the operation is abandoned.
I cannot use the CopyObject method as this creates a copy of the link to the back-end table, not a copy of the actual table itself, so I run a make table query which creates a copy of the tables in the front-end.
Can anyone tell me how to replace the linked tables in the back-end with the temporary tables that are in the front-end, maintaining the links.
Thanks!
I cannot use the CopyObject method as this creates a copy of the link to the back-end table, not a copy of the actual table itself, so I run a make table query which creates a copy of the tables in the front-end.
Can anyone tell me how to replace the linked tables in the back-end with the temporary tables that are in the front-end, maintaining the links.
Thanks!