Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: You do not have exclusive rights to the database at this time

    ADP 2000

    Create the project in a developement folder, repair and compact to a release folder, then distribute the project to user folders.

    User has a link to the project on their desktop

    Gave them dbo to the sql server database

    They get that message when the try to create a view

    BUT they don't get that message when they create a sproc.

    ANY Ideas welcomed
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Damn...Google ain't much help...


    It's funny because I don't have a problem...just the developer...ummm director
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    NoOne?

    Damn
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Still?

    OK then..should an ADP be local or on a server?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I run them locally.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    OK, I once had an issue where multiple users were connecting to an Access database on a shared resource. As I recall, if the user opened up Access and then navigated to the file, all was well, but if they opened the MDB file from an Icon on the desktop it defaulted to granting them exclusive access to the database, which they could not get if somebody else was already connected. The result was the error you are getting.

    Bear in mind that this was on Access 7.0, and applied to an MDB database, not and ADP project, but the solution was to include a parameter in the commandline for the icon that ensured the database was not opened exclusively.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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