PC Review


Reply
Thread Tools Rate Thread

In code, I need to copy and paste a table

 
 
David
Guest
Posts: n/a
 
      4th Feb 2005
I have an mde that uses an associated mdb for external
tables that are replicated. Since they are replicated, I
cannot make any changes to the structure of the table. I
no longer need the replication, but since this is a
distributed product with client specific records in the
external tables, I cannot make changes here and
redistribute the database without losing all the data the
clients have in their database without some kind of copy
routine. The simplest solution would be, from my mde, copy
the replicated table, paste it back with a different name,
rename the old table, rename the new table to the old
name, and then delete the old table. Is there a way that
anyone knows of that I can do in code to effect this.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Search one table to copy and paste select data to another table Sarah Microsoft Access VBA Modules 1 12th Dec 2008 06:42 PM
Macro to copy linked table and paste as local table =?Utf-8?B?Q2xpdmU=?= Microsoft Access 2 7th Sep 2007 10:56 AM
I keep getting this code <o:p> when I copy and paste. =?Utf-8?B?U2NhcnI=?= Microsoft Word Document Management 3 16th Feb 2007 07:18 PM
Copy/Paste does not copy a table from Access to SQL Server =?Utf-8?B?RnhKaW0=?= Microsoft Access 1 20th Sep 2006 07:18 PM
In code, copy and paste a table in another database David Microsoft Access Form Coding 1 5th Feb 2005 03:02 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:15 AM.