Split database - Updating tables?

[Guest]

I split my database yesterday and had to update a table today. I went to the
table dB and added a field. When I went back to the forms, queries, etc
program I do not see the field.

What do I do to get it to see the changes?

 

[Stefan Hoffmann]

hi Mark,

I split my database yesterday and had to update a table today. I went to the
table dB and added a field. When I went back to the forms, queries, etc
program I do not see the field.
What do I do to get it to see the changes?

You need to relink the table.

mfG
--> stefan <--

 

[Pat Hartman \(MVP\)]

Adding a new column to a table will not automatically add it to queries.
You need to modify every query that needs the additional column. As to
forms and reports, same thing. Controls are not automatically added, you
need to do it. Access has no way of knowing what modifications are required
by the addition of a field. Only you know.

If you have trouble getting a form or report to "see" new columns in a
query, delete the query name from the RecordSource property, save the
form/report, and then paste the query name back in. That makes Access
refresh the fields collection for the form/report so it will see new fields
added to its RecordSource.