Page 1 of 2 12 LastLast
Results 1 to 15 of 26
  1. #1
    Star Lounger
    Join Date
    Nov 2001
    Location
    Texas, USA
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Working in shared db (2000)

    I just upgraded to 2000 and find that when someone else is in the db, I can't make changes to forms, reports, etc. even if the other person is not using that form or report. Is there a way around this, or do I need to change my work hours?
    Also, I miss being able to type a word in the Help search- it's gone. Is there an alternative?

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Working in shared db (2000)

    Correct. If someone is using a database you can't make changes to forms, reports, etc in that same database. The only way around it is to split the database into a separate front-end and back-end, and then work on your own copy of the front-end, copying it to the other users when you're done. Making changes to forms and reports when someone else was in the database caused me major problems with corruption in A97 even when no one else was making any use of the forms/reports/etc that I was changing. I assume that's why it's no longer allowed.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Working in shared db (2000)

    I can still type a word into Help. What do you get?

    If you get the "office assistant" instead of what is shown below, look in its options and somewhere you can turn it off. (I can't find out how to get it back again, so I can't find the place to turn it off)
    Attached Images Attached Images
    Regards
    John



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

    Re: Working in shared db (2000)

    Don't turn off the answer wizard. There are all sorts of things you can't find in the index.
    Charlotte

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Working in shared db (2000)

    Hi Judy - it's been a while.
    As others have pointed out, one of the major changes from 97 to 2000 was to require that you have exclusive access to a database before you change forms, reports, macros or code. A major inconvienence from our perspective, but it added considerable stability to production databases. We use to have to get everyone [80 people at one of our clients] out on a fairly regular basis to fix a problem, and that eventually lead us to (nearly always) deploy the front-end to the user's workstation. Now we work away on a regular schedule, and when changes are ready to be deployed we simply have users exit their database and restart it and they automatically get the latest version. Check our web site for more details if you are interested.
    As for Help, it's more closely tied to the Office Assistant now, so you may want to use it to type search words - if not the Answer Wizard is useful.
    Hope all is going well with your upgrade - you may also discover some issues with 2000 wanting to always upgrade your 97 back-ends - there are several threads on that topic in the forum.
    Wendell

  6. #6
    Star Lounger
    Join Date
    Nov 2001
    Location
    Texas, USA
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Working in shared db (2000)

    Hi, Wendell. Nice to see you are still here. Unfortunately, my IS folk will not allow front end/ back end databases. I just can't convince them, period. Therefore I will have to shut everyone out when changes are needed. Bummer, but I at least understand why.
    Our conversion has had numerous bumps, not the least of which has been oddities in Word and Excel once Access 2000 was implemented. We hope those will be resolved by upgrading some of us to 2000 Professional, but who knows? In the meantime I find myself perplexed by changed structure, and results which differ from '97. I suspect I'll be asking lots of questions now.
    First and foremost is whether making graphs on reports based on table/query data is any easier in 2000? And why crosstab table headers which show perfectly in the report, disappear when exported to .rtf (they stay in snapshot)?
    I'll check your site out- thanks for the suggestion.
    Judy

  7. #7
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Working in shared db (2000)

    I was suggesting that the office assistant be turned off, not the answer wizard.
    Regards
    John



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

    Re: Working in shared db (2000)

    At my age, I'm entitled to misunderstand occasionally! <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    Charlotte

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

    Re: Working in shared db (2000)

    What exactly do you mean by "any easier"? It's pretty much the same in 2000 as it has been. Graphics and other things stay in snapshots but don't translate into rtf. You'll have to explain what you mean by crosstab table headings in the report.
    Charlotte

  10. #10
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Working in shared db (2000)

    Dare I ask what age that is?
    Pat <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

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

    Re: Working in shared db (2000)

    Old enough to know better! <img src=/S/granny.gif border=0 alt=granny width=20 height=20> (You *knew* I was going to answer that way, didn't you? <img src=/S/grin.gif border=0 alt=grin width=15 height=15>)
    Charlotte

  12. #12
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Working in shared db (2000)

    The intrigue continues ....

  13. #13
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Working in shared db (2000)

    Yes - but . . . She isn't as old as I am.
    Wendell

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

    Re: Working in shared db (2000)

    Hah! You'll *never* know! <img src=/S/devil.gif border=0 alt=devil width=15 height=15>
    Charlotte

  15. #15
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Working in shared db (2000)

    Hang on a minute, if W > C, then how does he know??

Page 1 of 2 12 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
  •