In VBA, how do I link two tables with the same name and specify the name.
I have two databases, each with a table called 'product'.
I already have it linked, via VBA, from my frontend to one database.
How do I link also to the table in the second database and name it something like Product_new
or should I just specify "IN" on a select and also update statements.
I want to selectively copy records from product in one database to product in another database
thanks in advance.