External Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am new to access. I need to link to an external database. With the
external database changing information daily I assume just to link to the
database. How do I refresh the data from these tables daily.

Thanks for your help--
ShelleyPA
 
Unless the name of the external database changes daily, you shouldn't have
to do anything: your linked table will always have the current data from
that external database.
 
Douglas,

Thanks for the information, but when you link to a dbase external file, the
changes done to the table in Access effects the external database, correct?
If this is so I would not have the option to link. So this means that I would
need to import the tables needed daily? Or could I use an append table with a
query for results needed? I 'm so confused. Thanks
 
Shelley said:
Douglas,

Thanks for the information, but when you link to a dbase external file,
the
changes done to the table in Access effects the external database,
correct?
Yes.

If this is so I would not have the option to link. So this means that I
would
need to import the tables needed daily? Or could I use an append table
with a
query for results needed? I 'm so confused. Thanks
Click to expand...

Use a "make table" query in the first instance and then use append, delete
and update queries to maintain the data. Sounds like a total nightmare to
me.

Keith.
www.keithwilby.com
 
Back
Top