Alpha Video Training
Results 1 to 2 of 2

Thread: User Rights Required for Table Updating

  1. #1
    Red Abicht
    Guest

    Default User Rights Required for Table Updating

    I'm running an application that appends records over a network to an Alpha Five table that is located on a computer that is running the Windows 2000 Server operating system. The server is in a Windows NT 4.0 domain. The application checks to make sure that the user has exclusive read-write access to the destination table before executing the append.

    At the moment, the share on the server gives "everyone" "full control". The other "Security Tab" and "Sharing Tab (Permissions)" are also enabled.

    The append operation causes an error which appears to be related to inability to gain exclusive access to the table to be appended. Although the code says open the table FILE_RW_EXCLUSIVE the table ends up being opened as "Read only, exclusive". This seems to be caused by insufficient user rights.

    What is the proper way to handle this situation?

    I can invoke an interim solution by making the users members of the "domain admins" group on the domain controller (a different computer). Such users can open the table "Read/write, exclusive". This is undesireable since these users have unlimited authority on the domain.


  2. #2
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,311

    Default RE: User Rights Required for Table Updating

    Red,

    If your app is running from shadowed databases on the local workstations, the discussion in this thread may be relevant.

    http://msgboard.alphasoftware.com/alphaphorum/read.php3?sortby=lastreply&direction=desc&num=4&id=69893&thread=69878#MSG69892

    -- tom

Similar Threads

  1. Client Login with limited user rights
    By Jared Sutherland in forum Web Application Server v6
    Replies: 4
    Last Post: 05-10-2005, 07:07 PM
  2. Current date required in table field default form
    By David Morgan in forum Alpha Five Version 6
    Replies: 2
    Last Post: 01-23-2005, 01:43 PM
  3. Help required with Table Lookups
    By Graham Wickens in forum Alpha Five Version 5
    Replies: 2
    Last Post: 03-27-2004, 04:52 AM
  4. Updating Two Fields From Another Table
    By George Noonan in forum Alpha Five Version 5
    Replies: 6
    Last Post: 02-09-2004, 05:37 AM
  5. UPDATING TABLE
    By Nip Lewis in forum Alpha Five Version 4
    Replies: 3
    Last Post: 06-10-2003, 09:50 AM

Bookmarks

Posting Permissions

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