Results 1 to 11 of 11
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    ? permission problem (Access 97)

    I have a database that I am attempting to run under a limited user account. When entering an order and placing an amount ordered into the field I get an error. "the field is too small to enter the amount of data you attempted to add" I know the field length is OK because I can run the same order under my admin account. I have tried giving full control of the database and the whole office folder to the limited user account but it doesn't work. I have other limited user accounts set up previously that worked OK. Now they don't work. Is this a Windows update problem causing this? (Windows XP). Any other suggestions. Thanks

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

    Re: ? permission problem (Access 97)

    That's a weird problem. I'm not aware of any Windows update that would cause this behavior.

    I assume that you are entering the order in a form. What happens if you try to enter the order directly into the relevant table under the limited account?

  3. #3
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ? permission problem (Access 97)

    What is the limited account? Are we talking an Access User Level Security account, or an NT account?

  4. #4
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ? permission problem (Access 97)

    I can add directly into the table. However, I have just tried it again and can now see that the problem is that it can't create an OrderNo (autonumber field) for the order. Still can't see why it won't under this limited user account ....sigh???

  5. #5
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ? permission problem (Access 97)

    The account is basically a group policy limited account. Its a generic account to give limited functionality to mainly a Citrix application but we also use it so staff can access a number of other programs for daily use. I don't have the specifics of what is locked down in group policy. Maybe I will have to investigate at that end.

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

    Re: ? permission problem (Access 97)

    Just to make sure, you weren't able to create an order directly in the table when you tried again?

  7. #7
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ? permission problem (Access 97)

    I can add an order directly to the table and it will create an order ID but using the order form links a number of tables so it may not be real test of the system.

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

    Re: ? permission problem (Access 97)

    I assume that the form is based on a query that links some tables together.
    Can you add a record in that query under the limited account?
    If not, try the following (still under the limited account):
    - Open the query in design view.
    - Click the Save button on the toolbar or select File | Save.
    - Close the query.
    - Open it in datasheet view and try to add a record again.

  9. #9
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ? permission problem (Access 97)

    Ok, so the account has nothing to do with Access itself, both the admin and the limited user are NT based accounts, and both are logging into the database with Admin (the default account). If that's the case, then it's not an Access issue, it's a file permission issue. Create a .txt file in the same folder as the .mdb, then log in with the limited account, and see if they can change the contents of that .txt file.

  10. #10
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    102
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ? permission problem (Access 97)

    I already know the limited account can do this. Plus I have given that acccount full control of the database itself and the whole suite of Office programs. But the problem remains. Its certainly a tricky one. Thanks for your help.

  11. #11
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: ? permission problem (Access 97)

    What about the folder that the database is in?

Posting Permissions

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