2007 extremely slow
in [Help]
|
From: Albert D. Kallal on 3 Apr 2010 19:47 Ok, so you do have linked tables. That is a REALLY big detail As mentioned, do you experience this problem with local applications without any linked tables? In other words, does this issue occur with all your applications, or only those with linked tables? (ones that use network resources)? And, is there any multi-user issues here? Are these applications used by more then one user at the same time. Since this seems to be a split application, then I assume the front end is on each computer. And assuming the above, then have you tried a persistent connection? In the front end, just open any linked table to the back end, now minimize that table. Now, with that table minimized, try running that form, does the delay go away? -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal(a)msn.com
From: Matthew Wells on 3 Apr 2010 21:47 Yes and no. There are linked tables, but I'm not using them. There is no recordsource in any form. When I maximize a form in design view is a good example. Either when I double click the title bar or when I use the usual max button it takes 5 minutes. I am on a shared drive -- Matthew Wells matthew.wells(a)firstbyte.net "Albert D. Kallal" <PleaseNOOOsPAMmkallal(a)msn.com> wrote in message news:vuQtn.37000$Ht4.26605(a)newsfe20.iad... > Ok, so you do have linked tables. That is a REALLY big detail > > As mentioned, do you experience this problem with local applications > without any linked tables? > > In other words, does this issue occur with all your applications, or only > those with linked tables? > (ones that use network resources)? > > And, is there any multi-user issues here? Are these applications used by > more then one user at the same time. > > Since this seems to be a split application, then I assume the front end is > on each computer. > > And assuming the above, then have you tried a persistent connection? > > In the front end, just open any linked table to the back end, now minimize > that table. > Now, with that table minimized, try running that form, does the delay go > away? > > > -- > Albert D. Kallal (Access MVP) > Edmonton, Alberta Canada > pleaseNOOSpamKallal(a)msn.com > >
From: Albert D. Kallal on 3 Apr 2010 23:16 "Matthew Wells" <matthew.wells(a)firstbyte.net> wrote in message news:0dStn.92523$gF5.37375(a)newsfe13.iad... > Yes and no. > There are linked tables, but I'm not using them. Well, that fact that you not using them still could be an issue. For testing and to determine if this your computer or Access, or something in your applications, it is important to eliminate these issues (even if for testing you use a 1 form tiny application with the wizard build in less time then it takes me to write this post). > I am on a shared drive Right, and so when you run something on a local drive without any linked tables, do you have the same problem? If yes: Then the performance issue still exists, then we still on the issue of computer + virus or some other issue. if no: Then obviously access CAN run fast and Access is NOT slow on your machine. This would tell us that Access runs well and thus it not necessary you computer or Access that is slow here. This then would hint to something due to the setup of your application. This would also suggest we not looking to change the configuration of access but is thus something in your application or network setup. However, if ALL AND EVERY application no matter what runs slow, then why bother with issues like network when no network is involved? So it is important here to determine the above yes or no issue to guide us on the next step here. -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal(a)msn.com
From: Matthew Wells on 4 Apr 2010 23:35 I put the file on the local c:. The SQL Server instance is on the same box, so everything is local. I changed Access to use tabbed docs. Now when I switch from form view to design view it takes 5 minutes. Also, no other program is giving me any problems - only Access 2007. I've tried while connected to the LAN and while I'm not. Same results. Still clueless. -- Matthew Wells matthew.wells(a)firstbyte.net "Albert D. Kallal" <PleaseNOOOsPAMmkallal(a)msn.com> wrote in message news:ZyTtn.92528$gF5.56348(a)newsfe13.iad... > "Matthew Wells" <matthew.wells(a)firstbyte.net> wrote in message > news:0dStn.92523$gF5.37375(a)newsfe13.iad... >> Yes and no. >> There are linked tables, but I'm not using them. > > Well, that fact that you not using them still could be an issue. > > For testing and to determine if this your computer or Access, or something > in your applications, it is important to eliminate these issues (even if > for testing you use a 1 form tiny application with the wizard build in > less time then it takes me to write this post). > >> I am on a shared drive > > Right, and so when you run something on a local drive without any linked > tables, do you have the same problem? > > If yes: > Then the performance issue still exists, then we still on the issue of > computer + virus or some other issue. > > if no: > Then obviously access CAN run fast and Access is NOT slow on your machine. > This would tell us that Access runs well and thus it not necessary you > computer or Access that is slow here. This then would hint to something > due to the setup of your application. This would also suggest we not > looking to change the configuration of access but is thus something in > your application or network setup. However, if ALL AND EVERY application > no matter what runs slow, then why bother with issues like network when no > network is involved? So it is important here to determine the above yes or > no issue to guide us on the next step here. > > -- > Albert D. Kallal (Access MVP) > Edmonton, Alberta Canada > pleaseNOOSpamKallal(a)msn.com > >
From: Albert D. Kallal on 5 Apr 2010 00:36
"Matthew Wells" <matthew.wells(a)firstbyte.net> wrote in message news:yUcun.32756$iu2.9136(a)newsfe15.iad... > I put the file on the local c:. The SQL Server instance is on the same > box, so everything is local. I changed Access to use tabbed docs. Now > when I switch from form view to design view it takes 5 minutes. Also, no > other program is giving me any problems - only Access 2007. I've tried > while connected to the LAN and while I'm not. Same results. > > Still clueless. Ok, this is good. Now we eliminated the network issue. The other question asked was does this slow down occur for all access applications, or just the one sql one you have? In other words, does a basic application with NO linked tables but ONLY local accdb tables run ok on your computer? if yes: Then access can run great and wonderful and fast on your computer and thus it something in the particular application. if no: Then access can NOT run great and wonderful for ALL applications and it has NOTHING to do with your ONE application. -- Albert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal(a)msn.com |