Recent content by Jaspos

To confirm, for the simple tests I have done the joins are definitely on PKs, but they remain read only in recordsets. Minty - I am unsure how I would link to SQL tables and do the joins in Access - do you mean set up all the linked SQL tables, and then write Access queries that do the joins...

Hi all, hoping some of the experts here might be able to help I am taking my first foray in Access with SQL Server as a back end. I am currently in testing, with my aim of moving most/all of the data processing to SQL Server rather than Access/JET. The approach I am currently trying is binding...