in Query properties what does Select Query (Replicated) mean? versus Query(Local)
in Query properties what does Select Query (Replicated) mean? versus Query(Local)
Exactly where do you see this?
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
I think this is a Access Web App thing?
Web Apps use SharePoint lists and are now deprecated and support for them is evaporating rapidly.
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
That info is found by right clicking on a query in the nav pane & clicking object properties
As mentioned by the OP, it will show the query type with either Replicated or Local in brackets.
In fact, the same info is shown for any Access object - not just queries
I believe it shows as Replicated if the project replicable property is true or if is has been imported from another project with that property
The information is nothing to do with Web Apps and dates back to at least 1999.
Its fairly esoteric stuff and can normally be ignored
See if these articles help: Make All Queries Replicable in Access - Contextures Blog, Implementing Database Replication with JRO | Microsoft Learn
Thanks for the clarification Colin.
I think my misunderstanding arrived due to only ever having seen that "feature" in a Web App or possibly an old Access Data Project (ADP)
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓