If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Time to open a table seems unusually long
I've noticed in one of my databases that it takes about 5 secondes to open
any of the tables in datasheet view (after double-clicking on the table icon in the database window), while most of the tables in my other databases open almost instantaneously. All of these tables are resident in their front end mdb file; that is, they're not linked to another database file. This condition persists regardless of whether the mdb file is in a local network drive or my own C: drive. It takes them about 5 seconds to display in datasheet view. I'm concerned about this because I believe that whatever is causing this, is also affecting the performance of my queries, forms and reports. What could cause this delay in opening these tables? Thanks in advance, Paul |
#2
|
|||
|
|||
If the table is local (not attached), this should do it:
1. Uncheck the boxes under: Tools | Options | General | Name AutoCorrect Explanation: http://allenbrowne.com/bug-03.html 2. Open the table in design view. Open the Properties box (View menu). Set SubdatasheetName to: [None] Save. Close 3. Compact the database: Tools | Database Utilities | Compact More info and options in the Access Performance FAQ at: http://www.granite.ab.ca/access/performancefaq.htm -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Paul Ponzelli" wrote in message ... I've noticed in one of my databases that it takes about 5 secondes to open any of the tables in datasheet view (after double-clicking on the table icon in the database window), while most of the tables in my other databases open almost instantaneously. All of these tables are resident in their front end mdb file; that is, they're not linked to another database file. This condition persists regardless of whether the mdb file is in a local network drive or my own C: drive. It takes them about 5 seconds to display in datasheet view. I'm concerned about this because I believe that whatever is causing this, is also affecting the performance of my queries, forms and reports. What could cause this delay in opening these tables? |
#3
|
|||
|
|||
Now it's much better. Thank you, Allen.
#2 (below) was the main culprit in my case. PP "Allen Browne" wrote in message ... If the table is local (not attached), this should do it: 1. Uncheck the boxes under: Tools | Options | General | Name AutoCorrect Explanation: http://allenbrowne.com/bug-03.html 2. Open the table in design view. Open the Properties box (View menu). Set SubdatasheetName to: [None] Save. Close 3. Compact the database: Tools | Database Utilities | Compact More info and options in the Access Performance FAQ at: http://www.granite.ab.ca/access/performancefaq.htm -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Paul Ponzelli" wrote in message ... I've noticed in one of my databases that it takes about 5 secondes to open any of the tables in datasheet view (after double-clicking on the table icon in the database window), while most of the tables in my other databases open almost instantaneously. All of these tables are resident in their front end mdb file; that is, they're not linked to another database file. This condition persists regardless of whether the mdb file is in a local network drive or my own C: drive. It takes them about 5 seconds to display in datasheet view. I'm concerned about this because I believe that whatever is causing this, is also affecting the performance of my queries, forms and reports. What could cause this delay in opening these tables? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Time to open a table seems unusually long | Paul Ponzelli | General Discussion | 2 | March 26th, 2005 03:40 AM |
Design help, please | SillySally | Using Forms | 27 | March 6th, 2005 04:11 AM |
Table Wizard Does Not Set Relationship if Foreign Key and Primary Key Name Do Not Match Exactly in Case. | HDW | Database Design | 3 | October 16th, 2004 03:42 AM |
Troubleshoot the SendObject method | Nikky_Pickles | General Discussion | 1 | August 30th, 2004 07:40 AM |