Hi,
I have a split database on a network (LAN). (The network is pretty fast...MS Word and other apps load quickly)
The Access database backend contains 1 major table with 65 fields and only 10 records in this table. I have a form in the front end. When I switch this form to design or layout view and drag & drop fields from my major table onto this form it takes ages (30sec) per drag & drop.
What's causing this? How can I fix it? Do I need indexing? Do I need to switch to an Access Project file structure?
2) The form (in normal mode) takes a while to load the fields onto the form. It is sluggish. However, scrolling through the 10 records on the form is ok (fast).
How can I speed up my form editing in Design or Layout mode?
Thanks.
New Info... I just tried adding a new blank form to my front end...drag & drop fields is now fast in Design or Layout mode on this new form. Therefore the problem appears to be specific to my original main form. This original form contains lots of fields plus I'm using a tab control on it. I'm beginning to think that forms should not contain too many fields (controls) or they slow down considerably during Layout or Design? Is this true? Is there a work around because if I split my fields across several forms then when the next form in the series is opened, the record number has reset to 1 so the user is now entering data into the wrong record? How is this problem handled? Thank you.
I have a split database on a network (LAN). (The network is pretty fast...MS Word and other apps load quickly)
The Access database backend contains 1 major table with 65 fields and only 10 records in this table. I have a form in the front end. When I switch this form to design or layout view and drag & drop fields from my major table onto this form it takes ages (30sec) per drag & drop.
What's causing this? How can I fix it? Do I need indexing? Do I need to switch to an Access Project file structure?
2) The form (in normal mode) takes a while to load the fields onto the form. It is sluggish. However, scrolling through the 10 records on the form is ok (fast).
How can I speed up my form editing in Design or Layout mode?
Thanks.
New Info... I just tried adding a new blank form to my front end...drag & drop fields is now fast in Design or Layout mode on this new form. Therefore the problem appears to be specific to my original main form. This original form contains lots of fields plus I'm using a tab control on it. I'm beginning to think that forms should not contain too many fields (controls) or they slow down considerably during Layout or Design? Is this true? Is there a work around because if I split my fields across several forms then when the next form in the series is opened, the record number has reset to 1 so the user is now entering data into the wrong record? How is this problem handled? Thank you.
Last edited:
