Linking Tables

[J P Singh]

Hi All

We have two access databased which are used by an ASP application.

We want to link a table in two databases but we only want 4 out of 6 fields
to be linked.

Is that possible?

 

[Kevin3NF]

Linking is at the table level, not field. You could create a query with the
relevant fields and link your ASP to that ( I think)

 

[J P Singh]

When linking tables the only tab present is the tables and not queries.

Any other suggestions how part data from one table in a database can be used
in another table in a second database

Many thanks

Jas

 

[Brendan Reynolds \(MVP\)]

You would have to break the table into two tables with a one-to-one
relationship.

The only reason I can think of for doing this would be where some of the
fields contained highly sensitive data and you wanted to apply different
levels of security to the table containing those fields. In most
circumstances, it would be simpler just to link the original table, create a
query including only the required fields, and have all data access go
through the query rather than directly to the table.