Link queries or forms/labels to a data base

[Guest]

Hi, I have a data base that contains names addresses, phone numbers, as well
as other data fields. My data base is actually a table called database
123006.mdb. What I would like to do is "link" various Access queries, forms
and reports to this data base file such that when information in the data
base file (.mdb) changes, the information shown in any of the queries, forms
or reports will also be reflect the information in the database 123006 the
next time I open the query/form/report. What happens now is that after the
mdb changes I have to reconstruct the query in design view to get the query
to pull up the latest information.

Hopefully this is a rather simple problem.

Thanks for your help,
Cali 54

 

[Rick Brandt]

Hi, I have a data base that contains names addresses, phone numbers,
as well as other data fields. My data base is actually a table
called database 123006.mdb. What I would like to do is "link"
various Access queries, forms and reports to this data base file such
that when information in the data base file (.mdb) changes, the
information shown in any of the queries, forms or reports will also
be reflect the information in the database 123006 the next time I
open the query/form/report. What happens now is that after the mdb
changes I have to reconstruct the query in design view to get the
query to pull up the latest information.

Hopefully this is a rather simple problem.

This should not be necessary at all if you are only talking about *data
changes*. Of course if you have a form, report, or query OPEN while the data is
being changed then it is true that those changes will not automatically appear.

A form can be requeried programmatically or from the menu to see the changes,
but a query or report would have to be re-run.

Actually you could issue a refresh on an open query and you would see changes
and deletions, but you cannot see new records without re-running the query.

 

[Guest]

Works just fine, Thanks Rick.

This should not be necessary at all if you are only talking about *data
changes*. Of course if you have a form, report, or query OPEN while the data is
being changed then it is true that those changes will not automatically appear.

A form can be requeried programmatically or from the menu to see the changes,
but a query or report would have to be re-run.

Actually you could issue a refresh on an open query and you would see changes
and deletions, but you cannot see new records without re-running the query.