Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2002 problems with 97 db (Access 2002)

    Hi,

    I have an internal call where the user recently got Office XP Prof SP3. The rest of her team is still on Access 97. The first day the user accessed the 97 db, the other teammates had to get out of the database. The user opened the db read only (eg without converting it). They all were able to work for the rest of the week.

    Then this week she started to have the error message: 'The db that you are trying to open or convert is currently in use, or you do not have permission to open it exclusively." There is more to the message but it doesn't seem to make sense if she was able to open the the db and work previously.

    Any ideas?

    How well does Access 2002 share A97 databases in amixed and multi-user environment? Any documentation on this?

    TIA,

    Jimmy

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

    Re: 2002 problems with 97 db (Access 2002)

    First of all, your users shouldn't all be trying to use the same database, although it's perfectly OK for them to work in local copies linked to the same data back end. Secondly, unlike 97, all later versions of Access require an exclusive lock on the database in order to make design changes of any kind. If someone else opens the database and makes changes, Access XP will not allow that user to open it as well because it needs to make a sort of temporary conversion and it can't do that when someone else is in there in 97. In addition, you're asking for trouble with your present scenario, because it will be too easy for the XP user to accidentally convert the database, which will make it completely unusable by the 97 users.
    Charlotte

Posting Permissions

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