I am trying to transfer the data and table structure from one database to another.

My database kept bloating so I moved my linked tables to a separate database and I’m attempting to pull them into a local table in my current DB. When I use the TransferDatabase it acts like it’s working but there is no data available.

DoCmd.TransferDatabase acLink, “Microsoft Access”, “C:UsersDesktopExternal_DataSources.accdb”, acTable, “tblLinked”, “tblLocal”, False

I am also not getting any errors.