devxlogo

Changing Database Structure

Changing Database Structure

Question:
I’m using VB 3.0 to work with databases in the Jet 2.0 format. I expect it will be necessary to add new fields to the database sometime in the future. Will I have to create a new database file and then transfer all the old records to the new table (plus the new fields) or can I simply add the new fields to the table and carry on?What is the best strategy to follow to make the addition of fields in the future as easy as possible?

Answer:
Microsoft Access databases and tables can have tables and fields added and changed at any point. Obviously, if you delete a field with data in it, you’ll lose the data. Same thing will happen if you reduce the size of a text field, for instance. The data that doesn’t fit will be truncated.

See also  5 Ways to Improve Customer Experience
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