Linked database question

  • Thread starter jjsaw5 via AccessMonster.com
  • Start date
J

jjsaw5 via AccessMonster.com

If i have a database linked into Access, and that database only allows "read-
only" access, and my other problem is the data i need to pull from it, the
column names do not match up with any of my other column names and i cannot
change them.


This is looking impossible to do but is there anyway i can bring up a record
on the read only database and have that record copied to another table?
 
W

wphx

I don't know if this is what you are looking for.

If you can see the data in the linked table from within access, you can
easily use an 'Append Query'. you will have to use the source and target
tables. when you set up the query, you can manually identify which field in
the source is to be sent to which field in the target. The query will then
append the data based on your criteria etc. to the target query
 
Top