Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 05-16-2012, 01:34 PM   #1
ramindya
Newly Registered User
 
Join Date: Feb 2012
Posts: 9
Thanks: 0
Thanked 1 Time in 1 Post
ramindya is on a distinguished road
Copy table from one database to another(current) database with data, indexes and keys

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!

ramindya is offline   Reply With Quote
Old 05-17-2012, 12:09 AM   #2
Trevor G
Newly Registered User
 
Trevor G's Avatar
 
Join Date: Oct 2009
Location: Tamworth, Staffordshire
Posts: 2,331
Thanks: 4
Thanked 229 Times in 219 Posts
Trevor G will become famous soon enough Trevor G will become famous soon enough
Re: Copy table from one database to another(current) database with data, indexes and

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?
__________________
Trevor
I am on a learning curve of life, I know a little but like to share what I have learnt with others.
I am using Microsoft Office 2003 To 2016
Please remember everyone here is a volunteer, so if you have had a reply to your thread be courteous and acknowledge this.
Trevor G is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy Table Data Macro To Another Database TimTDP Macros 2 06-26-2012 10:56 AM
Help with code to copy data from current form to separate table... Madlom Modules & VBA 3 08-01-2011 05:25 PM
Primary Keys and Indexes Cowboy Theory and practice of database design 18 08-26-2010 03:48 PM
Copy data from another database tpk Modules & VBA 1 06-10-2004 02:43 AM
Insert data from other database to current database htquang Modules & VBA 1 05-26-2004 04:31 AM




All times are GMT -8. The time now is 10:13 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World