devxlogo

Adding Fields to Existing Database

Adding Fields to Existing Database

Question:
How do I add new fields to an existing table in an Access 2.0 databasewithout losing data that already exists in the table/database? I knowhow to add fields, (the append method) but doesn’t this corrupt thedata already in the table?

Answer:
You can add fields with absolutely no ill effects to your database integrity. Obviously, if you have code based on the number of the fields in a table, for instance, that would have to change. If you remove a field, the only data you lose is what is in the field. You won’t have a problem with records being messed up because a field is missing.

See also  Using Consumer Trust to Help Build Brands On Major Social Platforms
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist