 | |
Forms Open More Slowly After Database Split
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Forms Open More Slowly After Database Split -
01-21-2009
, 06:11 PM
#2
| |||
| |||
|
|
I recently split my Access 2000 File Format database application at work, that previously resided on a shared server and was being accessed in a multi-user environment, over concerns that the database was more prone to corruption. After spliting the database and placing the FE on client PCs hard drives with BE being shared on the shared server (with the tables linked of course), user's are experiencing a delay of between 5-15 seconds for Table data input forms to open from the GUI switchboard form. This was not occurring previously as the forms would open almost immediately. I was under the impression that since the FE resided on each user's PC hard drive, forms within the FE would open much quicker than if the forms had to be accessed across the network. Can an MS Access MVP or anyone offer some guidance as to why this would be occurring? The workaround I'm using now is to have the users open the input forms and keep them minimized on their desktops until the program is closed at the end of the day. Thank you in advance for your assistance. I recommend Tony Toews page on splitting. |
My app speeded up by using a shorter name. But I implemented what I
could that is mentioned there.
#3
| |||
| |||
|
|
I recently split my Access 2000 File Format database application at work,* that previously resided on a shared server and was being accessed in a * multi-user environment, over concerns that the database was more prone to* corruption. *After spliting the database and placing the FE on client PCs * hard drives with BE being shared on the shared server (with the tables * linked of course), user's are experiencing a delay of between 5-15 seconds * for Table data input forms to open from the GUI switchboard form. *This* was not occurring previously as the forms would open almost immediately. * I was under the impression that since the FE resided on each user's PC * hard drive, forms within the FE would open much quicker than if the forms* had to be accessed across the network. *Can an MS Access MVP or anyone * offer some guidance as to why this would be occurring? *The workaround I'm * using now is to have the users open the input forms and keep them * minimized on their desktops until the program is closed at the end of the* day. *Thank you in advance for your assistance. -- Using Opera's revolutionary e-mail client:http://www.opera.com/mail/ |
#4
| |||
| |||
|
#5
| |||
| |||
|
|
Donald Calloway wrote: I recently split my Access 2000 File Format database application at work, that previously resided on a shared server and was being accessed in a multi-user environment, over concerns that the database was more prone to corruption. After spliting the database and placing the FE on client PCs hard drives with BE being shared on the shared server (with the tables linked of course), user's are experiencing a delay of between 5-15 seconds for Table data input forms to open from the GUI switchboard form. This was not occurring previously as the forms would open almost immediately. I was under the impression that since the FE resided on each user's PC hard drive, forms within the FE would open much quicker than if the forms had to be accessed across the network. Can an MS Access MVP or anyone offer some guidance as to why this would be occurring? The workaround I'm using now is to have the users open the input forms and keep them minimized on their desktops until the program is closed at the end of the day. Thank you in advance for your assistance. I recommend Tony Toews page on splitting. http://www.granite.ab.ca/access/spli...erformance.htm My app speeded up by using a shorter name. But I implemented what I could that is mentioned there. |
General Tab. This made the forms open about 15 times faster. Now, the
application behaves like it did before the database was split. Thanks for
the suggestion.
--
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
#6
| |||
| |||
|
|
On Wed, 21 Jan 2009 23:26:55 -0500, Salad <oil (AT) vinegar (DOT) com> wrote: Donald Calloway wrote: I recently split my Access 2000 File Format database application at work, that previously resided on a shared server and was being accessed in a multi-user environment, over concerns that the database was more prone to corruption. After spliting the database and placing the FE on client PCs hard drives with BE being shared on the shared server (with the tables linked of course), user's are experiencing a delay of between 5-15 seconds for Table data input forms to open from the GUI switchboard form. This was not occurring previously as the forms would open almost immediately. I was under the impression that since the FE resided on each user's PC hard drive, forms within the FE would open much quicker than if the forms had to be accessed across the network. Can an MS Access MVP or anyone offer some guidance as to why this would be occurring? The workaround I'm using now is to have the users open the input forms and keep them minimized on their desktops until the program is closed at the end of the day. Thank you in advance for your assistance. I recommend Tony Toews page on splitting. http://www.granite.ab.ca/access/spli...erformance.htm My app speeded up by using a shorter name. But I implemented what I could that is mentioned there. I implemented unchecking the Name AutoCorrect option under Tool | Options, General Tab. This made the forms open about 15 times faster. Now, the application behaves like it did before the database was split. Thanks for the suggestion. No problem. I wonder why Name Autocorrect is the default. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.