How to copy Table Design with out the Table Data ?

's Computer Specifications

we went to duplicate a child table in our data base...

but we don't want to duplicate the data in the table... just the fields and
field definitions

If we copy the table we get all the data too... right?

How can we copy the Table Design with out the Table Data

AND... have the Autonumber Fields _reset_ to start back at record number 1 ?

thanks for any help.

's Computer Specifications

In news:472a4351$0$32506$(E-Mail Removed),
Will <(E-Mail Removed)> wrote:
> we went to duplicate a child table in our data base...
>
> but we don't want to duplicate the data in the table... just the
> fields and field definitions
>
> If we copy the table we get all the data too... right?
>
> How can we copy the Table Design with out the Table Data
>
> AND... have the Autonumber Fields _reset_ to start back at record
> number 1 ?
> thanks for any help.

There are several ways to do this. One is to select the table, click
Copy, then Paste (or press Ctrl+C, Ctrl+V), and choose "Stucture Only"
as well as providing the new table name in the "Paste Table As" dialog.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

's Computer Specifications

manually or via code?

"Will" wrote:

> we went to duplicate a child table in our data base...
>
> but we don't want to duplicate the data in the table... just the fields and
> field definitions
>
> If we copy the table we get all the data too... right?
>
> How can we copy the Table Design with out the Table Data
>
> AND... have the Autonumber Fields _reset_ to start back at record number 1 ?
>
> thanks for any help.
>
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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
SQL Query to copy Data from One Table to another Table having same names but from different databases	apurv.agarwal@gmail.com	Microsoft Access Queries	1	20th Nov 2006 05:54 PM
VB2005 : Create table in Access - copy of another table but without the data	Screaming Eagles 101	Microsoft ADO .NET	2	18th Oct 2006 04:25 PM
How to copy 9 fields data from table to other table automatically	=?Utf-8?B?QWxhbjQ4?=	Microsoft Access VBA Modules	8	21st Jul 2005 01:28 AM
Copy table A data to table B & Still Linked?	=?Utf-8?B?VW5pdmVyc2VUTg==?=	Microsoft Access	0	10th Jan 2005 02:03 PM