I am building list boxes and forms with each record added. The purpose is to provide data entry people with the ability to add existing or new subject titles / author entries to new or existing newspaper titles. With hundred's of thousands of titles and subject entries the lookups for list boxes and forms can take some time.
--- In [email protected], "Richard Killey" <[EMAIL PROTECTED]> wrote: > wharmon97 (is that your real name?) > > if the forms are loading off the local computer, then they should be fast. > > one cause of being slow that I have seen is when the form you are opening > has numerous combo boxes or list boxes that source their data directly from > tables on the network drive. is this the case in yours? if not, can you > describe anything else the form might be doing that could explain the time > delay opening? > > > > Richard > > > > ------------------------ > Richard "Manxman" Killey > MS Access Developer > http://www.accessdatabasetips.com > > > > > -----Original Message----- > From: wharmon97 [mailto:[EMAIL PROTECTED] > Sent: Friday, April 09, 2004 1:02 PM > To: [email protected] > Subject: Re: [Access VBA Central] Microsoft Access and bandwidth issues > > > Yes, I have split this db into front end forms and the backend > tables. Currently have approx. 40,000 records data entered. > > > --- In [email protected], "Richard Killey" > <[EMAIL PROTECTED]> wrote: > > wharmon97 (you did not sign even your first name!!) > > > > Question # 1 - have you split your database into a front end > (forms on local > > machines) and a back end (tables on network drive)? > > > > If the answer is "NO" then do that first. It is the most common > method to > > solve your problem. It is documented in every single article/book > that > > discusses Access on a network. > > > > > > ------------------------ > > Richard "Manxman" Killey > > MS Access Developer > > http://www.accessdatabasetips.com > > > > > > > > > > > > -----Original Message----- > > From: wharmon97 [mailto:[EMAIL PROTECTED] > > Sent: Thursday, April 08, 2004 7:53 PM > > To: [email protected] > > Subject: [Access VBA Central] Microsoft Access and bandwidth issues > > > > > > Hi, > > > > Have up to 6 Access stations on a single switch adding records to a > > set of (currently) Access tables over a single 10MB wire. There > are > > a couple of things happening that seem to have to do with > > bandwidth. Most telling is that it can take up to several minutes > > for Access to open and display a form. Once inside the form data > > entry goes smoothly enough. On a stand-alone station the form > opens > > quickly. When only one or two stations are operating forms open > > quickly. > > > > I have very purposefully set up these stattions to add records to > > the main table using temporary tables that only add records when > > a "Next record" command button is clicked. This was for several > > reasons including avoiding record primary key and file locking > > conflicts. I have a routine that finds a next available record > > number and adds the record avoiding contention with other stations > > adding to the same table. > > > > This is all data entry of new records for the moment so I do not > > suspect file locking problems. > > > > Anybody want to relate what they know about how much bandwidth is > > needed for Access to behave properly in a multi-user session? > > > > And, thanks. > > > > > > > > > > > > Yahoo! Groups Links > > > > > > Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessVBACentral/ <*> 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/
