Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / February 2008

Tip: Looking for answers? Try searching our database.

Using same structure.

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cheese - 07 Feb 2008 22:22 GMT
Is there a fast way to recreate the structure of a database without the data?
I would like to use the design but not the data...

Thanks!
Cheese
Jeanette Cunningham - 07 Feb 2008 22:35 GMT
Cheese,
Make a copy of each table. Right click a table, choose copy, choose
structure only.
Access will make a copy of the table with all the structure but no data.
The next problem is naming the tables with names that are exactly the same
as the ones you copied so they will work with the queries, forms, reports
and modules.
One possibility is to rename the original tables by adding a prefix to each
name such as z, then you can rename your new tables to the same names that
the original tables used.

Jeanette Cunningham

> Is there a fast way to recreate the structure of a database without the
> data?
> I would like to use the design but not the data...
>
> Thanks!
> Cheese
Cheese - 07 Feb 2008 22:50 GMT
Jeanette,

Thank you, I was aware of this capability but was hopeful that there was
something abit simpler.

> Cheese,
> Make a copy of each table. Right click a table, choose copy, choose
[quoted text clipped - 15 lines]
> > Thanks!
> > Cheese
Jeanette Cunningham - 07 Feb 2008 23:05 GMT
There is a way to do this all in one go.
Create a new blank database. Import the tables from the other database - in
the import wizard there is an option to import tables as structure only.

Jeanette Cunningham

> Jeanette,
>
[quoted text clipped - 23 lines]
>> > Thanks!
>> > Cheese
Jeff Boyce - 07 Feb 2008 22:52 GMT
Jeanette described how.

Now, ?why?!

If you are attempting to solve some problem using a relational database
(e.g., Access), and want multiple tables with identical structure, you
probably need to go back to the drawing board!

For example, if you used a table to store data from 2006, you might think
you want to make a copy so you can store the same kind of data for 2007 (and
again, for 2008, and again, for ...).  As they say in the game shows,
BZZZZZZ!

Use a single table, and add a field for the year.  Better yet, in most
instances, add a field for a date/time value.  With a design like this, you
want to start data for a new year, just put the data in with the date in the
new year!

If you'll describe a bit more specifically why you want to do this, the
newsgroup readers may be able to offer more specific suggestions...

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

> Is there a fast way to recreate the structure of a database without the
> data?
> I would like to use the design but not the data...
>
> Thanks!
> Cheese
John W. Vinson - 07 Feb 2008 23:15 GMT
>Is there a fast way to recreate the structure of a database without the data?
> I would like to use the design but not the data...
>
>Thanks!
>Cheese

With the caveats in Jeff's post in mind, if you want to clone the structure of
A.MDB in a new B.MDB, create B.MDB; and use File... Get External Data...
Import to import everything. There's an option when you import the tables to
import the structure only, or structure and data.

            John W. Vinson [MVP]
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.