Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
recordset vs collection
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 collection so i'm not constantly requerying the db, but it's occoured to me for this that if i use a collection and close the recordset then it';s concievably possible that another user might access one of the already open records and change the data leading to a concurrancy problem. Would using a recordset to return the results and use as the source for the data displayed in the form solve this problem? Thanks Keith |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
recordset vs collection
Only if same record is accessed by multiple users,there is a chance it will error.
You can introduce a key field and for records in review you can tick them while it's open. If record is ticked no other user can modify the records,but view is closed key field can be unchecked. On Thursday, 13 February 2014 16:07:13 UTC+5:30, Keith Willis wrote: 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 collection so i'm not constantly requerying the db, but it's occoured to me for this that if i use a collection and close the recordset then it';s concievably possible that another user might access one of the already open records and change the data leading to a concurrancy problem. Would using a recordset to return the results and use as the source for the data displayed in the form solve this problem? Thanks Keith |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
recordset vs collection
Adding the extra overhead by loading a recordset into a collection
isn't very practical, IMO, because you can manipulate the recordset much easier via ADO. Kind of makes the extra step to populate a collection a waste of time/resources. My point assumes you use ADO to read/write the data in the SQL db! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I check a collection (e.g. worksheets) collection to be empty? | Excel Programming | |||
Cannot use recordset twice with copy From recordset | Excel Programming | |||
Recordset's RowID as part of Recordset | Excel Programming | |||
Type recordset/recordset? | Excel Programming |