By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,479 Members | 1,601 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,479 IT Pros & Developers. It's quick & easy.

Slow After split (tried everything)

P: 36
Hi

Again the same subject. I have tried everything what is recommended what I could find and it is still so slow.

I open the db file in the root of the network and it takes 2s to open the table I'm interested (1500 records) but when I open the same table (linked) using FE which is on local desktop it takes 6-7s.

(I have switched off subdatasheet and it has the latest SP and updates, after compacting, its in 2007 format running on XP Pro with SP3)


Any ideas?

Many thanks in advance
Emil
Jun 25 '09 #1
Share this Question
Share on Google+
3 Replies


puppydogbuddy
Expert 100+
P: 1,923
Are you certain that you've installed the latest service pack, Office 2007 SP2?It just became available in late April and early May 2009.

Issues fixed by SP2
http://download.microsoft.com/downlo...20Changes.xlsx



http://www.microsoft.com/downloads/d...displaylang=en

http://support.microsoft.com/kb/953195
Jun 25 '09 #2

puppydogbuddy
Expert 100+
P: 1,923
PS: See this link for a checklist in relation to performance problems:

http://www.granite.ab.ca/access/performancefaq.htm
Jun 25 '09 #3

P: 36
Hi

Thanks for that. This is now resolved it was actually a network issue and was fixed by company network people.

Next time first thing I will check how long it takes to open a table (FE) to eliminate antivirus and network problems straight away ;)

Thanks
Emil
Jun 28 '09 #4

Post your reply

Sign in to post your reply or Sign up for a free account.