CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 9 of 9
  1. #1
    Join Date
    Jul 2009
    Location
    Genova - Italy
    Posts
    38

    [RESOLVED] ACCESS 2003 can't run as exclusive

    Hello to all

    I have an ACCESS 2000 mdb file with some code inside.
    In the old computer, where ACCESS 2000 was installed, there wasn't any problem to open it in exclusive mode.
    Now I am trying to open it in exclusive mode in the new computer where ACCESS 2003 is installed but the software tell me that it can't be opened in exclusive mode because someone else is using it. But this is false!
    The database i am trying to open is in locale, on my pc.

    Does anyone know why?

    Thanks in advance

    Fabrizio

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,430

    Re: ACCESS 2003 can't run as exclusive

    Check whether .ldb file exists. If exists - try to delete it before opening .mdb
    Victor Nijegorodov

  3. #3
    Join Date
    Jul 2009
    Location
    Genova - Italy
    Posts
    38

    Re: ACCESS 2003 can't run as exclusive

    Hello

    There is any .ldb file in .mdb directory. It is be possible that this file is created in different directory?

    Thank you

  4. #4
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,430

    Re: ACCESS 2003 can't run as exclusive

    Victor Nijegorodov

  5. #5
    Join Date
    Jul 2009
    Location
    Genova - Italy
    Posts
    38

    Re: ACCESS 2003 can't run as exclusive

    Hello

    I followed the guide, but I have noticed nothing special.
    I also opened .ldb file with a notepad, and in there i found that only one user (I) is using the DB.
    This drive me crazy!!!!

    Thank you for your help!

  6. #6
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,430

    Re: ACCESS 2003 can't run as exclusive

    Did you try to delete .ldb before opening .mdb?
    Victor Nijegorodov

  7. #7
    Join Date
    Jul 2009
    Location
    Genova - Italy
    Posts
    38

    Re: ACCESS 2003 can't run as exclusive

    I don't have any .ldb file before to open the .mdb.
    This is really my issue.
    This problem may be related to the .mdb password?

  8. #8
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,430

    Re: ACCESS 2003 can't run as exclusive

    I don't know. I never worked with Access 2003 (only 97 and 2000)
    Victor Nijegorodov

  9. #9
    Join Date
    Jul 2009
    Location
    Genova - Italy
    Posts
    38

    Re: ACCESS 2003 can't run as exclusive

    After 1 day of tests, I solved it. I created a new ACCESS 2003 database in which I imported all the material from old DB. And now all works well, finally.

    Thank you VictorN for your help.

    Best regards

    Fabrizio

Posting Permissions

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





Click Here to Expand Forum to Full Width

Featured