Data type removal

[Bri]

When creating a database and a field name is entered, and
then not used, is there a way to delete or remove the
data type from the data base, so that you dont have
extranious fields. Access 2000

 

[John Vinson]

When creating a database and a field name is entered, and
then not used, is there a way to delete or remove the
data type from the data base, so that you dont have
extranious fields. Access 2000

Yes, but it can be a chore: it depends on where and how extensively
you have referenced the field. The hard way is to MAKE A COPY of your
database, and delete the field from the table; test the database
extensively and fix all the forms, queries, reports and code that
break.

Less tedious is to get a third party search and replace tool and use
it to track down all the field references:

Free:
http://www3.bc.sympatico.ca/starthere/findandreplace
Find and Replace: http://www.rickworld.com
Speed Ferret: http://www.moshannon.com
Total Access Analyzer: http://www.fmsinc.com