Page 1 of 3 123 LastLast
Results 1 to 15 of 38

Thread: Access XP

  1. #1
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Access XP

    Does anyone have info on whether Access XP cures any of the problems of Access 2000, such as (and especially) performance issues? I was at Office XP launch, and could find no-one from Microsoft who knew anything about Access.

    All I've been able to find out since then is that you have a choice of using either Access2000 or AccessXP format for database. Apparently AccessXP format offers performance gains, so I guess if you choose to use Access2000 format things are as bad as before.

    -- Mark Liquorman
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access XP

    I haven't tried XP yet, but I like 2000 and develop in it. The conventional wisdom is usually to give a new version time to settle down a bit, so you might try addressing whatever problems you're having with 2000 while you wait for the dust to settle.
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access XP

    Actually, I don't have any problem with A2000, because I never upgraded to it! On the Access forum in Compuserve, however, one of the most frequent questions we get is from people who upgraded to A2000 and have immediate performance problems. Another frequent questions is "Why is A2000 Help so bad?"; I know of some people who keep A97 open while working on A2000, merely so they can switch to it to use Help!
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access XP

    Ah, yes, I've seen some of the same posts. Usually the poster hasn't discovered that using a 97 backend is barely practical in Access 2000, they haven't turned off subdatasheets, and they're still using Name Autocorrect. Once you deal with those issues, its performance is quite comparable to Access 97.
    Charlotte

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Winnipeg, Canada
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access XP

    Where can I turn off SubDatasheets - there's nothing in Tools|Options|Datasheets that I can see relates to Subdatasheets. I unchecked all Name Autocorrect boxes on the General tab. Thanks Charlotte!

    I am not certain what is meant by Help being 'bad' (as compared to other Helps - I have never found an EASY Help
    that does not force me to scan thru reams of unrelated info and many levels of hyperlinks just at a time when I am in a hurry to find an answer to a seemingly easy question - maybe I just don't have the temperament and/or mental organizing ability to deal with this @%#&).

    My problem with Access Help has been (after several installs) that it continues to ask for the CD even though Help loads in a minimized version on the screen. It's more of an annoyance than a quality issue.

    TIA

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access XP

    The HTML help is much harder to navigate than the previous versions. I got used to using the Find tab exclusively in previous versions, but it doesn't exist in HTML help and the Answer Wizard doesn't do a full text search. Even the MS support people sometimes have trouble finding stuff in it. Plus, it differs depending on whether you're in the UI or in the VBE, which can be terribly confusing. I've found the best way to work with it is to use the Answer Wizard and type in the equivalent of "how do I ...", which usually gives me something approximating what I'm looking for, but not always.

    Unfortunately, subdatasheets are properties of the individual tables and you can only turn them off by opening the table in design view and then bringing up the properties dialog and setting subdatasheet to [none] (it's set to [auto] by default. You can also do it from code, which is the method I generally use. There is code in <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q261/0/00.ASP>KB Article Q261000: Slower Performance on Linked Tables</A> to turn off subdatasheets, but I wrote my own before I found Microsoft's. You also have to watch out for new tables (i.e., make-table queries) because they are all created with the subdatasheet property set to [auto] and there is no way to change the default. BTW that's also true of the Name Autocorrect--it has to be turned off in each new database.
    Charlotte

  7. #7
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access XP

    Thanks for the info on autocorrect, I'd never heard of that being a problem. As for subdatasheets, is that a problem only if you use datasheets? (Personally, I never use them; I always use a continuous form). I tried to access that article Q261000 in MSKB that you mentioned in another post, but that link appears to be broken (I even went to MSKB site and tried to get it).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  8. #8
    2 Star Lounger
    Join Date
    Dec 2000
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access XP

    Get to the "Knowledgebase Search Screen", don't pick a Microsoft product, then change the "Search By" to "Specific Article ID Number", type in Q261000 in "My Question is", and voila, you got it. Don't quite understand why the link doesn't work, it brings up the same exact URL Charlotte posted.

    FWIW

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access XP

    I don't know what happened to the link, but it definitely isn't working. Follow TomGs advice to get the article the other way. Here's the link the the search page: <A target="_blank" HREF=http://search.support.microsoft.com/kb/c.asp?fr=0&SD=GN&LN=EN-US>http://search.support.microsoft.com/kb/c.a...&SD=GN&LN=EN-US</A>

    There are several knowledge base articles on Name Autocorrect, and it's been implicated in all sorts of bizarre behavior in Access 2000. Subdatasheets are table properties and have nothing to do with datasheet view. They seem to have been thought up by someone who forgot that the resulting queries would be layered under form queries, etc.. They can seriously delay loading of tables, let alone forms, especially if the tables are linked. If you are using linked tables, by the way, you need to change the subdatasheet property in the BACK END.
    Charlotte

  10. #10
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access XP

    Did you actually try to call-up the document, or did you just see it in the list of search results? Searching for Q261000 produced a search list with the document on it, but selecting the document from the list is when I get the "page not found"
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  11. #11
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access XP

    See my response to Tom's post. MSKB lists the article, but when I select it to display, that's when I get the "page not found". And I can't figure out how to tell Microsoft!

    BTW, what is that little red symbol with an 'M' in it next to your name?
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  12. #12
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access XP

    The symbol just means I'm a moderator.

    I don't know what's going on with the link. It isn't something I copied from text, I actually went to the search window, entered the article number and pulled up the article, then pasted the link from there. Now, when I go to the search window and enter the article number, it returns a link to the article, but clicking on the link takes me to an error screen.

    What's even weirder is that if I click the link on the error page that says "Microsoft Product Support Services", it takes me to <A target="_blank" HREF=http://support.microsoft.com/directory/>http://support.microsoft.com/directory/</A>, but the page says "United Kingdom Product Support". Clicking the "Support Home" link also takes you to the UK site.

    Unless they've actually revoked our Declaration of Independence (I'm from California), there's something wrong with the MS site. Either they've screwed up or they've been hacked again.
    Charlotte

  13. #13
    DaveShmave
    Guest

    Re: Access XP

    Hi All,

    You might want to read this free article from Smart Access for more information (it's a review) on Access 2002: <A target="_blank" HREF=http://www.smartaccessnewsletter.com/sa/SAMag.nsf/0/AC0D639DB103043D85256A55005B3B79>http://www.smartaccessnewsletter.com/sa/SA...5256A55005B3B79</A>

    Dave

  14. #14
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access XP

    Well, I'm sure they must have been hacked, because Microsoft doesn't mess-up! Just ask them. I was at recent XP launch event, and noticed that MS people referred several times to "when your PC crashes", but NEVER said "when Windows crashes".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  15. #15
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Access XP

    Oddly enough, tonight when I search on the article number, I find no matches. but if I click the link I posted earlier for the article, it goes straight to it. I think I'm losing my grip. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    Charlotte

Page 1 of 3 123 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •