Updating Linked Table Data

C

cw

Is it possible to update / append data from a local table TO a Linked Table?

For some reason when I create a new Query - the linked table does not appear
in the list of available objects in the Design View of my Query.
 
J

John W. Vinson

Is it possible to update / append data from a local table TO a Linked Table?
Click to expand...

Sure. I do it all the time.
For some reason when I create a new Query - the linked table does not appear
in the list of available objects in the Design View of my Query.
Click to expand...

Odd. Do you in fact have it linked using File... Get External Data... Link?
Does it show up in the Tables window?
 
C

cw

Yes. that is exactly how I linked the table in.

When I go to Query/Design View to start a query from scratch - the linked
tables do not show up in the list of available tables.

Any ideas?
 
C

cw

John,

Thanks-I figured it out. Those files are linked to a shared environment. If
I am not connected to the shared environment - then the files show up as a
table in Access but they are not accessable to build queries against. Makes
a lot of sense - I guess I was just being blond. :)

Thanks for the help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linked worksheet connection error 5
Append query in Access to SQL Server 2
Append Query to a Linked Table 2
Create field from append query based on linked table name 1
Refreshing Data Daily From a Linked Excel Spreadsheet 4
not supported by ISAM 3
linked view from database, Can append but not refresh- help? 1
Linked Tables Append Query(ies) 4

Top