Linked table design and queries

[Guest]

Hi All,

I have a linked table which reports on orders. It contains a field called
'Auth_No' as well as many other fields.

I want to add in whether the order was 'Valid' however as its a linked table
I can't add the field.

I've thought of using a make table query then adding the field to the table
created in Access. However the linked table updates daily with new orders so
when I go to run the make table query again it duplicates records. The same
can be said with the Append query etc.

Can anyone help me please? How can I add the 'Valid' field ? The Valid field
will need to be a "Yes/No" format field.

 

[Joseph Meehan]

Hi All,

I have a linked table which reports on orders. It contains a field
called 'Auth_No' as well as many other fields.

I want to add in whether the order was 'Valid' however as its a
linked table I can't add the field.

I've thought of using a make table query then adding the field to the
table created in Access. However the linked table updates daily with
new orders so when I go to run the make table query again it
duplicates records. The same can be said with the Append query etc.

Can anyone help me please? How can I add the 'Valid' field ? The
Valid field will need to be a "Yes/No" format field.

How about a new table linked to the original table (one to one) with
just two fields, the field linking them and the additional field you want.
Then just create a query with both tables.

 

[Guest]

Thanks for the reply joseph. Though forgive me I'm new to Access.

How do I go about doing this? When I link a table it makes it read-only.

 

[Albert D. Kallal]

Are you just trying add a new field to a existing table?

Just open up the back end table, and bring up the table in design mode, and
add the new field.

All structure changes to your database must be done in the back end part.

 

[Guest]

I do not have access to the back end tables.

 

[Joseph Meehan]

Thanks for the reply joseph. Though forgive me I'm new to Access.

How do I go about doing this? When I link a table it makes it
read-only.

Are you sure you have full access to the table and to the directory
where it is located?