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.

PAR wrote:
Well, you could create a new database called DataBlank.mdb (you choose
name).

Now from the menu in Datablank select File/GetExternalData/Import and
select your backend database with data. Select all tables. Now select
the "Options" button. The default is Definition and Data. Change that
to Definition Only. Then hit the OK button.

Of course, you'd need to relink the tables to the new backend in the
frontend.

You can select Tools/Database Utilities/Linked Table Manager (select
Always Prompt For New Location in bottom left) or use code. Here's some
code to relink. http://www.mvps.org/access/tables/tbl0009.htm or use
Google to find other examples.

Thank You for the easy to follow instructions. Worked perfect! Thanks a
million!







"Salad"

PAR wrote:

some lookup tables. You'd want to keep those if they are static. Ex:
a status codes table.

Thanks! I compared all tables with the original database (Apps & Data) and
everything is there.


"Salad"