I have a 2003 MS Access database using 2000 file format. The database was
originally written with Access 2 (1995) and upgraded to where it currently
is. The database is split into APPS and DATA. I want to give the database to
someone else, but without my data. How can I either erase all of my data
(over 18000 records) or create a new blank data table and link it to the
APPS? My programming knowledge is minimal, so explain in baby steps please.
If there is a more appropriate NG to post this question, please let me know.
Thanks in advance.

Do not erase the data
1 ) create a new blank database same name with 1 added.on removeable
drive ( i.e. books.mdb will be books1.mdb )
2 ) go to file then get external data then import
3 ) select your database
4 ) go to table then select all then Queries and select all then forms
till modules and select all then press options and tick all imports and
click definition only on import tables then press ok
5 ) now close your database save if requested
6 ) right click on new database then rename back to file name ie
books.mdb
7 ) run this new database to check it works
i hope this helps



"PAR" <servedbypar (AT) gmail (DOT) com> wrote