Page 1 of 2 12 LastLast
Results 1 to 15 of 23
  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

    User cannot create query in Access 97 (XP Professional)

    We have PC's connected to a domain network using Windows XP Pro. When a user who has power user status on his PC tries to create a query in access 97 or import an Excel file he basically gets a message denying him access to do this. An user with administrator access can do this with no problems. Now, we do not want to give users admin access to their PC's. Obviously this is a Microsoft security "feature" but is there perhaps a registry setting that can give him access to do these things or do we have to bite the bullet and set him up as a local admin.

  2. #2
    Gold Lounger Rebel's Avatar
    Join Date
    Jul 2001
    Location
    Canada
    Posts
    3,024
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: User cannot create query in Access 97 (XP Professional)

    Is the user trying to create a query AND import a spreadsheet into Access? If so, this is probably not XP related, but rather an Access security issue. You will have to set up security within Access to enable or disable privileges.
    John
    A Child's Mind, Once Stretched by Imagination...
    Never Regains Its Original Dimensions

  3. #3
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User cannot create query in Access 97 (XP Prof

    Does the EU have ownership rights to the Database? If not, can you give them to him? As he already far enough inside the DB to create queries, it sounds like it is not an Access security issue.

    From what you say, I take it that he is trying to carry out the development work on his own hard drive. Is that really so?
    Gre

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: User cannot create query in Access 97 (XP Professional)

    Another possibility to check is to make sure that he has full priviledges to the folder in which the database resides - Access requires that in order to allow the user to modify the database, compact it and so forth.
    Wendell

  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: User cannot create query in Access 97 (XP Professional)

    The user himself created the database when he was using Windows NT. Now he has a new PC running Windows XP Pro and is having problems with the database since switching. The database is located on a network drive he has full access to. If he uses his old NT PC he can still use the database with no problems.

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

    Re: User cannot create query in Access 97 (XP Prof

    The user himself created the database when he was using Windows NT. Now he has a new PC running Windows XP Pro and is having problems with the database since switching. The database is located on a network drive he has full access to. If he uses his old NT PC he can still use the database with no problems.

  7. #7
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: User cannot create query in Access 97 (XP Prof

    Is he using the same login on both PCs?

    Joe
    Joe

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

    Re: User cannot create query in Access 97 (XP Prof

    Yes, that hasn't changed. We had another user who swapped form WinNT to W2K who had a similar problem. Changing him to power user worked OK but not it seems with Windows XP Pro.

  9. #9
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User cannot create query in Access 97 (XP Prof

    Has the End User tried creating a new Database on his Windows XP machine and then importing all the objects from the old Database? HTH
    Gre

  10. #10
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: User cannot create query in Access 97 (XP Prof

    Is he logging into the domain or to the local PC?

    Joe
    Joe

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

    Re: User cannot create query in Access 97 (XP Prof

    He logs on to the domain.

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

    Re: User cannot create query in Access 97 (XP Prof

    No have not tried this. Do you think that security is set up differently if the user creates the dataabse? This will not help for other databases he has to access. (of which there are many) It would be too much work to create them all again on his PC.

  13. #13
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: User cannot create query in Access 97 (XP Prof

    I have not tried recreating databases in bulk, but, in principle, it should only take a few minutes per database. You say ltlle about your set-up, but, in a number of cases, it would not necessarily be likely that a developer would have to go back and create new queries in most of them. Are there no plans to upgrade your Access licences from 97 to 2003? It may be the case that this is an Access 97 only issue. If there is no Office upgrade planned and the exisitng databases are "high maintenance", you seem to have little choice but to grant Admin permissions on his local machine. HTH
    Gre

  14. #14
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,572
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: User cannot create query in Access 97 (XP Prof

    Was Office installed by a local administrator user? Is it fully patched? Try this google search: access 97 security group:microsoft.public.windowsxp.*
    It should give you lots to investigate.

    Joe
    Joe

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

    Re: User cannot create query in Access 97 (XP Prof

    Yes its the same.

Page 1 of 2 12 LastLast

Posting Permissions

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