Rather than use the Query method which I am unsure on how to do I am physically copying the fields into new tables and then pasting the data manually. Thank you for your input I am doing what you said manually instead of through a query.
*Note using Access 2019/2016 will not read Access 97...
DoCmd.RunCommand acCmdConvertLinkedTableToLocal - Confirming it's not an Access 97 built in command
VB6 works with Access 97 but I am not sure if it works with 2000+
Convert Linked Table to Local Table in Access 97
I have tried;
Copy and paste method but it seems i have to append to an existing table with the exact same fields.
Using VBA in 97 doesn't allow to make a local copy
All other user interfaces have been explored.
So how do we convert linked...
My gamer tag Ephestion has been around for a long time. I'm also trying to update old programs that I had almost but never completed. I am using VB6 and Access 97.