How to change back end database structure.
Q: Peter Matthews writes: “If you have split a data base, and then decide to change the data structure – say to add some extra information to a table – is this a problem? There does not seem to be any way of recombining the files. I am not concerned with a multi user environment.”
A: To add new fields to the tables in the back end, you need to open the back end database itself, and make the changes. Then open the front end and make corresponding changes to queries, forms and reports to deal with the new fields.
You can recombine the back end and front end at any time (say if you don’t need to support multiple users) by first deleting the links, and then importing the tables from the back end into the front end database.
