We have an Access application using Jet. I added some new indexes yesterday and now they are being blamed for poor Access application performance. I then dropped the new indexes. The poor performance continued until the Access application was re-linked to the SS2000 database. Then things returned to normal.
Question, does Access/Jet persist SqlServer schema info in its MDB (or elsewhere?) I am told that the MDB is copied from a share to the local PC where it grows during its use. Some people are saying the MDB persists schema info about the SS2000 schema which influences how Jet accesses the SS2000 database. Is that true? Is there a link where I can read about this? I am a dba and am not an Access developer . . .
Thanks!
Michael
For linked tables in a JET database, I believe the schema is cached locally but it's not clear to me how that could result in a performance issue. You might want to post this to a Jet/Access newsgroup.
Regards,
Uwa.
|||Thanks for your response. Can you suggest an appropriate newsgroup?
Michael
|||access.tablesdbdesignAll Office forums & newsgroups
No comments:
Post a Comment