Question Starting out again with access and sql server (1 Viewer)

[roosn]

hi

I am trying to resurrect the use of data i previously used with good effect that was stored on sql server from 6 years ago, using access 2013.

in the sql server database i have a list of approx 100,000 document references, each document may have more than one revision, so i have another table 'tbl_ref_rev' related to the 'tbl_ref' table,

the reference revision table has approx 120,000 records

i then need a master query to show a list of the latest reference revision, which i know how to write in both access or sql server

but which is the best policy

a) in access link the tables from sql server and make a query from the linked tables or,

b) in sql server create a view and link that view to access 2013 as table

thanks in advance

roosn

 

[CJ_London]

either method will work but probably slightly more efficient to create a view