Hi Jimbobob, > I am using an access database to store the data, and am > wondering first, what the best way of grabbing and > sending to the database would be;
IMO, straight SQL. > and second, how/if I should store all the info in memory, No, you should not. 1) It's a waste of memory. 2) It's a concurrency nightmare (multiple users WILL experience data errors). 3) Why re-invent the wheel? This is why we have ADO. > I have a list of between 500-700 customers and am not sure > if storing them in a collection, or array is the best way > to deal with the problem. A recordset, actually, and ideally you would NEVER push that many records into your users face. Create a filter list that 'onchange' triggers a timer that will filter the results (sample here: http://ReliableAnswers.com/VB/Samples.asp#fado ). The idea is to reduce your user interface to ONLY what is absolutely necessary to provide the user the functionality they need. If you push a list of 700 customers into a listbox you're going to make it quite a PITA to find the one they really want (try scrolling up and down that thing for a single record!). After you get the simple interface stuff (add/edit/delete) out of the way you can work on improving the methods to speed up input and automate many of the common actions. Regards, Shawn K. Hall http://ReliableAnswers.com/ '// ======================================================== Yes, you're very smart. Shut up. -- 'Grandfather', The Princess Bride ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
