developingprogrammer
asked on
edit recordset records without hitting network database
hey guys, i've got a conceptual question.
my BE lies on the network and i want to avoid jumping to it so many times. here's what i think i can do:
1) create a recordset object
2) currentdb.openrecordset (so now all the records are in memory)
3) findfirst, nomatch, whichever operations i want, then edit the fields in the record and call rs.Update
4) once i'm am done editing all the multiple records and all the fields in the records i need, then i call a certain method to update the actual tables behind the recordset
how can i do step 4? of course assuming i'm opening a recordset from an editable source = )
my BE lies on the network and i want to avoid jumping to it so many times. here's what i think i can do:
1) create a recordset object
2) currentdb.openrecordset (so now all the records are in memory)
3) findfirst, nomatch, whichever operations i want, then edit the fields in the record and call rs.Update
4) once i'm am done editing all the multiple records and all the fields in the records i need, then i call a certain method to update the actual tables behind the recordset
how can i do step 4? of course assuming i'm opening a recordset from an editable source = )
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
1) I don't know
2) I don't understand what you mean by this.
Where would the records exist (as records) if they weren't in a recordset?
2) I don't understand what you mean by this.
Where would the records exist (as records) if they weren't in a recordset?
ASKER
2) yup they are in a recordset just that i can't do something like
Me.Recordsource = rsSomething
because i'm trying to set recordsource to recordset, different data types.
how should i correctly set the Me.Recordsource to a recordset object?
Me.Recordsource = rsSomething
because i'm trying to set recordsource to recordset, different data types.
how should i correctly set the Me.Recordsource to a recordset object?
Me.Recordset = recordsetname
After you've opened the recordset, of course!
After you've opened the recordset, of course!
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
thanks jim, you've been capturing my though process in every single question you answer or observe. it's definitely very reassuring to read your posts as you always give me a very sound and 360 awareness of what's going on, what i should do, which direction i should head.
i read all your posts very carefully and agree with everything you say.
the organisation i work for adopts a very "carefully carefully" mentality, vis a vis other truly driven organisations where it's a "GEEEEETTTT ITTTT DONNEEEEE!!!!" mentality. even using an Access database is causing a huge hoo ha over things already. so i have to delicately handle the perceptions whilst building a business case to advance projects that will truly bring real world benefits, not just political gains.
i'm a rarity in my organisation in that i've got a glimpse of what's possible from small readings here are there, come up with a vision far greater than my capabilities, satisfied with the challenge and the benefits, then rapidly improve till i can execute this vision. people like me are aplenty in other organisations but in mine, it seems that everyone just wants to keep their jobs and it's unbelievably uninspiring these unintelligent and lacking courage human beings. of course some are good, but as for myself, i'm gonna push myself till i almost permanently break, quickly apply CPR to myself and take on the next challenge. life is meant to be lived to its fullest and living life has limits on hedonism, but is infinite in contributions to others. so i will work with the situations i'm in now restricting me to Access and build a great software for them = )
P.S. this exercise in Access has been fantastic and my bigger vision is iOS and then websites. then, i will need a lot more guidance from you and the other experts here, so if yall can be patient with me till then as you've always been with me now, i'm most indebted = )
Jim, for website development on the Mac, what should i use? in windows it would undoubtedly be C# and visual studio for me with IIS. what is its equivalent on the mac? AND this tool should be very iOS website development friendly as well = )
thanks so much once again for your most insightful and wonderful guidance = )
i read all your posts very carefully and agree with everything you say.
the organisation i work for adopts a very "carefully carefully" mentality, vis a vis other truly driven organisations where it's a "GEEEEETTTT ITTTT DONNEEEEE!!!!" mentality. even using an Access database is causing a huge hoo ha over things already. so i have to delicately handle the perceptions whilst building a business case to advance projects that will truly bring real world benefits, not just political gains.
i'm a rarity in my organisation in that i've got a glimpse of what's possible from small readings here are there, come up with a vision far greater than my capabilities, satisfied with the challenge and the benefits, then rapidly improve till i can execute this vision. people like me are aplenty in other organisations but in mine, it seems that everyone just wants to keep their jobs and it's unbelievably uninspiring these unintelligent and lacking courage human beings. of course some are good, but as for myself, i'm gonna push myself till i almost permanently break, quickly apply CPR to myself and take on the next challenge. life is meant to be lived to its fullest and living life has limits on hedonism, but is infinite in contributions to others. so i will work with the situations i'm in now restricting me to Access and build a great software for them = )
P.S. this exercise in Access has been fantastic and my bigger vision is iOS and then websites. then, i will need a lot more guidance from you and the other experts here, so if yall can be patient with me till then as you've always been with me now, i'm most indebted = )
Jim, for website development on the Mac, what should i use? in windows it would undoubtedly be C# and visual studio for me with IIS. what is its equivalent on the mac? AND this tool should be very iOS website development friendly as well = )
thanks so much once again for your most insightful and wonderful guidance = )
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
questions
1) can i have the same effect using transactions?
2) can i set the recordsource of a form to the records in a recordset? i just read the recordset help file and it seems that i can only set the recordset of the form to the recordset object, but that may change the recordsettype and a few other things