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

Mods have slowed the database

P: n/a
All
I made some changes to A2000 mdb whilst working in A2002.I did not
convert the file format to 2002.Now it is released some forms that I
didnt touch are taking 15 secs to open whereas in the original they
took 2 secs.
The database compiled OK
I tried deleting and recreating indexes to no avial
Compact and repair no effect
It uses linked tables to a backend

Any ideas

thanks for the earlier comments i received
THe problem seems clearly related to the access mde rather than the
opeating systems as I first thought
Tony
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
It appears that Access tries to be too clever and caches information about
the linked tables. If they are not exactly as expected, the caching results
in much worse performance.

Tony Toews has details on this and other performance issues with Access 2000
and later at:
http://www.granite.ab.ca/accsmstr.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Tony Miller" <tc****@xtra.co.nz> wrote in message
news:19**************************@posting.google.c om...
All
I made some changes to A2000 mdb whilst working in A2002.I did not
convert the file format to 2002.Now it is released some forms that I
didnt touch are taking 15 secs to open whereas in the original they
took 2 secs.
The database compiled OK
I tried deleting and recreating indexes to no avial
Compact and repair no effect
It uses linked tables to a backend

Any ideas

thanks for the earlier comments i received
THe problem seems clearly related to the access mde rather than the
opeating systems as I first thought
Tony

Nov 12 '05 #2

P: n/a
Tony Toews site a great help on performance FAQ you dont read in the
handbook
Turned name autocorrect off and the forms opened 3 times faster
Thanks
"Allen Browne" <ab***************@bigpond.net.au> wrote in message
news:1w********************@news-server.bigpond.net.au...
It appears that Access tries to be too clever and caches information about
the linked tables. If they are not exactly as expected, the caching results in much worse performance.

Tony Toews has details on this and other performance issues with Access 2000 and later at:
http://www.granite.ab.ca/accsmstr.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html

"Tony Miller" <tc****@xtra.co.nz> wrote in message
news:19**************************@posting.google.c om...
All
I made some changes to A2000 mdb whilst working in A2002.I did not
convert the file format to 2002.Now it is released some forms that I
didnt touch are taking 15 secs to open whereas in the original they
took 2 secs.
The database compiled OK
I tried deleting and recreating indexes to no avial
Compact and repair no effect
It uses linked tables to a backend

Any ideas

thanks for the earlier comments i received
THe problem seems clearly related to the access mde rather than the
opeating systems as I first thought
Tony


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.