$$Excel-Macros$$ Re: recordset vs collections

2014-02-13 Thread Keith Willis
> > Hi > >From what i understand I want to use pessemistic record level locking and this is the default behaviour of the recordset object when used so do i actually need to make any amendments to my normal use of code i.e. The current record being used by ADOrecordset is pessemistically locked

$$Excel-Macros$$ Re: recordset vs collections

2014-02-13 Thread Keith Willis
> > Hi Enrique > Thanks for getting back to me, are you able to post an example, i'm a bit new to this and the help system is being decidedly unhelpful :) Thanks Keith -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Faceb

$$Excel-Macros$$ recordset vs collections

2014-02-13 Thread Keith Willis
Hi all I'm developing a project thats going to be a excel front end to a SQL db. One part of the required functionality is that you performa a search on the database and return possibly mutliple records for review or amendment on a userform. Normally i read data from a recordset into a collecti