Avatar of Andy Brown
Andy Brown
Flag for United Kingdom of Great Britain and Northern Ireland

asked on 

Multiple users accessing a single table - minimising issues

I have a table with about 50 records in it (Access 2016).  When users first load into the application, I want them to be able to pull in a two values from the same record (there will be a criteria such as [LiveActivites] = True).  In the past I may have used Dlookup, but in 2003, I used to get issues when several people ran this function at the same time, so I ended up creating a recordset and read the value that way.

I need to know what is the safest/fastest way to pull in these values.  It doesn't need to write anything back.
Microsoft Access

Avatar of undefined
Last Comment
Andy Brown

8/22/2022 - Mon