Improve company productivity with a Business Account.Sign Up

x
?
Solved

MS Access 2010 Slow Switching From Form View To Form Design - HELP!

Posted on 2011-09-13
7
Medium Priority
?
1,106 Views
Last Modified: 2012-05-12
Hi

I have an MS Access 2010 Database which is fairly complex. It was originally a 2003 database. I have created a new & very simple form.

If I open the form in 'Design View' it opens instantly.

If I open the form to view it, it opens instantly.

If, when the form is open in normal 'Form View' mode, I right click on the title bar and select 'Design View' it can take anything up to a couple of minutes to open. The form contains almost no code, is not attached to a table, has one unbound fielld in it.

The form is not modal

The form is not pop-up.

The database has been compacted & repaired.

The database has been rebuilt by creating a new file and importing all the objects.

If I open the database in Access 2003, opening the form and switching between form and design view causes no problems.

Help!
0
Comment
Question by:BlueSunbeam2
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 59
ID: 36529001

 This rings a bell and for the life of me, I can't remember what it was...hum only thing that comes to mind at the moment (and I may be totally off base with this), but do you have any mapped drives that are un-available?

Jim.
0
 
LVL 86
ID: 36529005
In some cases, this can be caused by the connection to the datasource - if that connection is slow or having troubles, the form (or report) can be very slow to open. That's difficult to troubleshoot, however, so first try these:

Have you turned off Name AutoCorrect? This is under Access Options - Current database.

If you have, and you still have troubles with the form, then you might try a Decompile. Make a backup first, then build a standard desktop shortcut with this as the Target:

"full path to msaccess.exe" "full path to your db" /decompile

Run this, then open your database, switch to the VBA Editor and click Debug - Compile. Fix any errors, and continue doing this until the menuitem is disabled. Now compact the db again.

If this doesn't help, you might have a corrupt form. You can try the SaveAsText method to recreate the form. From the immediate window, enter this:

SaveAsText(acForm, "FormName", currentproject.Path & "\FormName.txt")

Now delete the form, close/reopen the database, compact it, and then use LoadFromText to recreate it:

LoadFromText(acForm, "FormName", currentproject.Path & "\FormName.txt")

This will force Access to recreate the form from scratch, and can fix corruption in some instances.

Unfortunately, if that doesn't work, then you may be left with rebuilding it from scratch, or importing from a known good backup.
0
 
LVL 86

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 36529009
Also: have you applied all necessary patches and updates to Office/Access and Windows?
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36529471
Ya know, I never really trusted running Access "Format" databases that are more then 1 version away form what they were created in...

ex: Running an Access 97 db in Access 2002
Running an access 2003 db in Access 2010


Now, to be clear, I do it all the time...
Most of my apps are access 2003 that I run in 2007.

But there is always this little twinge I get deep down inside that make me nervous whenever I Compact and Repair a 2003 format DB within access 2007.

Again, nothing has ever happened, but I always make backups just in case...

So what am I getting at..?
I'm just curious as to if this issue goes away if you convert the db to the Access 2010 format...
Not saying that this will be the ultimate solution, I'm just curious...


JeffCoachman
0
 

Author Closing Comment

by:BlueSunbeam2
ID: 36529493
Missed the obvious, having been with Access since 97 I should now better! SP1 sorted it, just glad I didnt have to go down the re-build route, many thanks to you (and the other) contributors for the rapid response
0
 

Author Comment

by:BlueSunbeam2
ID: 36529507
Just for JeffCoachman's info, the database is in 2003 format and moving it to 2010 format did not resolve the issue, it was clearly an issue with 2010 itself which was fixed by SP1
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 36529969
ok
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…

584 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question