Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How do I erase data from database?

1 view
Skip to first unread message

PAR

unread,
Jul 4, 2010, 10:15:41 PM7/4/10
to
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.


Ken Snell

unread,
Jul 5, 2010, 8:08:06 AM7/5/10
to
Create a new database, then in that database, go to File | Get External Data
| Import menu.

There, navigate to the current database file, and when the wizard window
opens, select the objects that you want to import. For the tables, you'll
find a checkbox in the lower half of the wizard window that you can
check/uncheck for bringing over just table structures or table structures
with data. You'll want the structures without data.

Then import the objects.

Then you can link the front end file (or a copy of the front end file) to
this new backend file.

--

Ken Snell
http://www.accessmvp.com/KDSnell/


"PAR" <serve...@gmail.com> wrote in message
news:uL6dnbiFLNbS3azR...@giganews.com...

0 new messages