Refreshing Data

[Guest]

I have 6 tables already imported, however, the original files have just been
updated with new data. How can I refresh the tables with the new data? I
would think Access has a process similar to updating pivot tables (clicking
on the exclamation point icon). Any Ideas?

Thanks

 

[Danny J. Lesandrini]

If you want the Access data to match the files, Link to them instead of importing.

 

[Guest]

I tried that but I can't add new fields. The files have one extra variable
appended on the end so I just want to add it in design view and populate that
field by hitting a refresh button.
--
Regards,
Dave

If you want the Access data to match the files, Link to them instead of importing.

--

Danny J. Lesandrini
(e-mail address removed)
http://amazecreations.com/datafast/

 

[George Nicholson]

Link the tables (not import), then create a query for each of your tables
where you will add your extra field that will "refresh" every time you run
the query.
Then base all your forms, etc. on the queries, not on the tables.

--
George Nicholson

Remove 'Junk' from return address.

I tried that but I can't add new fields. The files have one extra variable
appended on the end so I just want to add it in design view and populate
that
field by hitting a refresh button.

 

[Guest]

I would prefer to change the source table to add the additional field/fields.
If that isn't possible, try to negotiate adding a new table with the
additional field/fields to the source database so that referential integrity
can be enforced between the two tables. Failing either of those, I would
create a new table that holds ONLY the primary key and whatever data
field/fields you need to add to the table. Link the tables from the other
database so you don't have to worry about refreshing their data. In your
application, use a query with a LEFT JOIN rather than an INNER JOIN to join
the linked table to your new local table. The reason for the left join is to
allow you to "see" newly added records for which you have not yet added your
local fields.

If it is possible for rows to be deleted from the linked table, you would
need to delete them from your local table also. To do that, run a query when
the database opens that locates these orphan records and deletes them.

I tried that but I can't add new fields. The files have one extra variable
appended on the end so I just want to add it in design view and populate that
field by hitting a refresh button.