• ? permission problem (Access 97)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » ? permission problem (Access 97)

    Author
    Topic
    WSamacs
    AskWoody Lounger
    January 3, 2008 at 3:05 am #447383

    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

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSHansV
      AskWoody Lounger
      January 3, 2008 at 11:06 am #1090822

      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?

      Reply | Quote
      • WSamacs
        AskWoody Lounger
        January 4, 2008 at 12:43 am #1091020

        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???

        Reply | Quote
        • WSHansV
          AskWoody Lounger
          January 4, 2008 at 12:54 am #1091024

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

          Reply | Quote
          • WSamacs
            AskWoody Lounger
            January 4, 2008 at 1:32 am #1091029

            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.

            Reply | Quote
            • WSHansV
              AskWoody Lounger
              January 4, 2008 at 1:39 am #1091033

              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.

              Reply | Quote
    • WSDrew
      AskWoody Lounger
      January 4, 2008 at 12:20 am #1091002

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

      Reply | Quote
      • WSamacs
        AskWoody Lounger
        January 4, 2008 at 12:46 am #1091021

        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.

        Reply | Quote
        • WSDrew
          AskWoody Lounger
          January 4, 2008 at 1:58 am #1091044

          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.

          Reply | Quote
          • WSamacs
            AskWoody Lounger
            January 4, 2008 at 2:09 am #1091048

            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.

            Reply | Quote
            • WSDrew
              AskWoody Lounger
              January 4, 2008 at 4:23 pm #1091130

              What about the folder that the database is in?

              Reply | Quote
    Viewing 1 reply thread
    Reply To: ? permission problem (Access 97)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    March 2025
    S M T W T F S
     1
    2345678
    9101112131415
    16171819202122
    23242526272829
    3031  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.