Copy table from one database to another(current) database with data, indexes and keys (1 Viewer)

There is source database named DBsource with source table named tblA_MainBaseTable and destination database named DBDest with destination table table named tblA_MainBaseTable (same as source table)

Now I want to delete the existing tblA_MainBaseTable in the DBDest and copy the new one from DBsource with data and indexes.

DBSource is MS ACCESS 2010 (.accdb) and DBDest is MS ACCESS 2003.

Found the following link but I am getting lot of error messages if I use this sample code.
support microsoft com/kb/108147

Anybody has working sample source code ? I am new to VBA and MS ACCESS. Any help would be greatly appreciated.Thanks!

You should place in your thread that you have also used another forum.

You were advised about copy object.

What have you tried and please show your code.

Do the tables have relationships?