Ref. odbcdirectcursorlibrary
http://msdn.microsoft.com/library/de...sorlibrary.asp

I do not really know if odbcdirectcursorlibrary is relevant for Access, but I am guessing it can be. If it is;

- Is it possible to use dbOptimisticValue within Access/VBA? Do ADO or DAO or both support that option?

Daniel