Copying Linked Tables Programmatically

[DarkWolff]

Is there a way to copy a linked table using VBA that keeps the original tables keys, character limits, etc.?



I am trying to code a system to push table updates from one location to a satellite backend. I can use a make table to copy the table, but it only copies the data. The database requires the keys for validation purposes.

[DarkWolff]

I just figured it out. For those in the future that need to do the same, you can do so with the DoCmd.TransferDatabase method.