transfer data from one access db to another access db in vb6.0

[subratamaji]

how can i transfer all tables from one access db to another access db dynamically in visual basic 6.0

end user should have choice to select the table from the source database.

[debasisdas]

If you want to create copy the entire database then simply copy the file and nename it into a new location.