Removing all records

R

Ramesh

HI,

i have a database with many tables. i now need the clean database file
without any of the records. is there a simple way to remove all the records
from this file? Or do i have open each table and delete all the records
manually.

Thanks for any direction.

Ramesh
 
6

'69 Camaro

Hi, Ramesh.
i now need the clean database file without any of the records. is there a
simple way to remove all the records from this file?
Click to expand...

Create a new database. Select the File -> Get External Data -> Import...
menu and navigate to the original database.. Import all of the objects by
selecting the "Select All" button on each tab. However, on the "Tables" tab
also select the "Options > >" button to expand the dialog window. In the
center "Import Tables" section, the "Definition and Data" option is checked.
Change that to "Definition Only." It would probably be a good idea to also
select the "Menus and Toolbars" and "Import/Export Specs" options, too.

Your new database will have all of the database objects that the original
database had, sans the data.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
T

Tony Toews [MVP]

Create a new database. Select the File -> Get External Data -> Import...
menu and navigate to the original database.. Import all of the objects by
selecting the "Select All" button on each tab. However, on the "Tables" tab
also select the "Options > >" button to expand the dialog window. In the
center "Import Tables" section, the "Definition and Data" option is checked.
Change that to "Definition Only." It would probably be a good idea to also
select the "Menus and Toolbars" and "Import/Export Specs" options, too.

Your new database will have all of the database objects that the original
database had, sans the data.
Click to expand...

Also to copy the relationships window if it's any complexity at all.

Use the sysrels utility at the following location to copy the table
relationships layout window
http://www.trigeminal.com/lang/1033/utility.asp?ItemID=12#12
Or use Save Restore Modify Relationship Window at
http://www.lebans.com/saverelationshipview.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
R

Ramesh

Thanks Camaro and Tony for your inputs. Job got so simply done!!!!

Tony, didnt quite get the purpose of the relatinship window copy. With the
Import utility, the relationships have also got copied and i can see them in
the relationship window. am i missing something?

thanks again
Ramesh
 
T

Tony Toews [MVP]

Ramesh said:
Thanks Camaro and Tony for your inputs. Job got so simply done!!!!

Tony, didnt quite get the purpose of the relatinship window copy. With the
Import utility, the relationships have also got copied and i can see them in
the relationship window. am i missing something?
Click to expand...

But did the layout come across? If you only have 10 or 20 tables not
a big deal for you to manually tidy up. One app I created had 160
tables so that was a pain point for me.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
6

'69 Camaro

Hi, Ramesh.
With the Import utility, the relationships have also got copied and i can
see them in the relationship window. am i missing something?
Click to expand...

The relationships are copied to the new database file, but the relationships
diagram's layout often looks like speghetti. If the layout looked like
speghetti in the original database, then one may not care that it looks the
same in the copy of the database. But many of us would rather have a neat
and tidy relationships diagram, and those utilities provide an easy means of
allowing us to only have to do it once, instead of on every copied database
file.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
Top