Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jun 2004
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Exclusive Access message (Access 2000 & SQL Server 2000)

    We have a client is running an Access (2000) front-end with a SQL Server back-end. Although the database is being used multi-user, non one is in design view of anything or has the database opened exclusively, however, some of the users get the following message periodically....

    "You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later".

    Some of the users are accessing the database using a Terminal Services box instead of a PC. Also, all the users are defaulted as Current User "Admin" as they are not using a central Workgroup Info (MDW) file. Could either of these be causing the problem....?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Exclusive Access message (Access 2000 & SQL Server 2000)

    Does the database contain code that (tries to) save database objects? For example, if a form is closed using the code

    DoCmd.Close acForm, Me.Name, acSaveYes

    the acSaveYes argument does not save the current record, as many people think (that is done automatically), but the design of the form.

    Also, if full menus and toolbars are available to the users, the Save button on the toolbar does not save the current record, but the design of the form. Many users user think it should be used to save a record.

    Another point: do all users, including those using Terminal Services, have full rigfhts in the folder containing the database? Access requires that. If the user can't create/modify the .ldb file, problems will occur.

  3. #3
    Lounger
    Join Date
    Jun 2004
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Exclusive Access message (Access 2000 & SQL Server 2000)

    Many thanks Hans.... I will look into these possibilities!

Posting Permissions

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