Linking external db into table

  • Thread starter Thread starter Angie
  • Start date Start date
A

Angie

I am trying to link an external db, on a network drive, to a d I am creating.
I have never done this before. I have linked the table I need to the db, but
I cannot figure out how to get those values into my table. Also, I have to
make it so that if a box is checked in the origional, it enters a word in my
table.
When I finally get all this done, I need to have link to the forms, and
reports. I am lost. I can navigate through Access well enough to work with a
db, but build one?

Please Help! :(
 
design the local table you want.

build a query using that linked table as its source

once the the query is working - i.e. returning the records/fields you would
like for your own table; then redefine this query as an Append Query. (in
menu bar select 'Query' and you will see it as one of the choices) It will
ask which table you want to append to....and you will select your local table
then identify the correct field to append to....
 
when I tryi to run the query, it tells me :

Microsoft Access set 97 feilds to null due to a type conversion failure, and
it didn't add 0 records to the table due to key violations, 0 records due to
lock violations, and 2061 records due to validation rule violations.
Do you want to run the action query anyway?
To ignore the errors and run the query, click yes.
For an exp ...click help.

How do I fix it? it is the validaton in the linked table, or in mine?
 
your defined local table's field formats differ from the linked tables'

i.e. one can not append a number type field into a text type field......
all you need to do is to compare the two data types field by field....just
look at the linked table in design view and note the definition of the fields
- - - make sure your local tables definitions agree....
 
Back
Top