Linking tables from different database

[allboutdB]

Hi there,

I am developing a new dB and i am trying to link a table from an existing database, my problem is that the table in the existing database is not normalized, so i am trying to normalize the table in the new database and link fields from the existing table, is there any way that access allows you to link only certain fields from the existing table to the new tables rather than the whole table, because if i link the entire table i will be faced with the same denormalized table. If not could you create materialized views in access

 

[boblarson]

No, you can't do this like this. But, you can link the table and then you can create queries which can act like tables.

 

[allboutdB]

Hi there,

Thanks for the quick reply, so i guesss than i will have to write VBA code to keep the queries udpate?

Cheers

 

[boblarson]

Hi there,

Thanks for the quick reply, so i guesss than i will have to write VBA code to keep the queries udpate?

Cheers

Why? If you use queries (and not tables) that are based on the linked table, then the data is always current.

 

[allboutdB]

Hi Bob,

may be i did not explain properly, in order to keep the data current wouldn't i have to run the query each time, or does the query refresh itself, rather than manually running the query , i could say maybe have it updated as soon as i open the a form or the database, make sense or am i stupid lol

Cheers

 

[Atomic Shrimp]

If you create queries, then treat them as tables, they'll be requeried on demand each time you use them.

 

[boblarson]

If you create queries, then treat them as tables, they'll be requeried on demand each time you use them.

Exactly! thanks Mike.

 

[allboutdB]

Thanks guys

This is great help, i better start reading on that

Cheers