Linked database question

  • Thread starter Thread starter jjsaw5 via AccessMonster.com
  • Start date 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?
 
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
 
You must log in or register to reply here.

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

Record-Locking remains open after closing 0
Separate Form 0
Excel Excel - Two Database Formula extraction? 3
copying a whole record from one table to another 3
Copy and move Access 13 database on laptop to pc with Access 13 0
Filling in fields to a partially complete record in a table using a form 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Link to Database - Password 1

Back
Top