Database structure copy

[Reed]

Yes,
1) Create a blank database.
2) Then go File > import and point to the database that
you want to copy the structure. It will prompt you for the
rest.

Hope this helps

Reed

 

[L. T. Portella]

Question:
When I create a blank database (I guess it is really a blank table) doesn't
it ask me for the structure (I guess it is really the various fields).

Could you explain this a little bit. I also have a table (with defined
fields of course) and wish to duplicate the table. How can I do it? If at
all possible please explain it on a step by step basis. It is ironic in the
stone age of database with DBase III all you had to do was to issue the
command: "copy structure to....." and bingo it was done.

Thanks

 

[Brendan Reynolds \(MVP\)]

A blank database is *not* a blank table. One of the major differences
between Access and the xBase family is that an Access MDB is a single
container that can contain multiple tables, queries, forms, reports, etc.
(In multi-user apps, we mostly use one 'back end' data MDB for the tables,
and one 'front end' application MDB for everything else). When you create a
new MDB you are just creating the container, it does not yet contain any
tables or other objects (other than system tables, used internally by Access
and/or Jet).

If you want to create a new database with the same structure as an existing
database, but without the data, first create the empty MDB, then go to File,
Get External Data, Import. Select the database you want to import from, and
select the tables you want to import. Now, before clicking on 'OK', click on
'Options', and you will see an option to import 'Definition and Date' or
'Definition Only'.