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.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
User cannot create query in Access 97 (XP Professional)
Home » Forums » AskWoody support » Windows » Windows Vista, XP and earlier » Questions: Vista, XP back to 3.1 » User cannot create query in Access 97 (XP Professional)
- This topic has 42 replies, 6 voices, and was last updated 21 years, 1 month ago.
Viewing 4 reply threadsAuthorReplies-
WSRebel
AskWoody Lounger -
WSamacs
AskWoody LoungerMarch 31, 2004 at 9:53 pm #807889The 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.
-
-
WSRebel
AskWoody Lounger -
WSunkamunka
AskWoody LoungerMarch 31, 2004 at 4:13 pm #807610Does 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?
-
WSamacs
AskWoody LoungerMarch 31, 2004 at 9:54 pm #807890The 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.
-
joep517
AskWoody MVP -
WSamacs
AskWoody Lounger -
WSunkamunka
AskWoody Lounger -
WSamacs
AskWoody Lounger -
WSunkamunka
AskWoody LoungerApril 2, 2004 at 1:43 am #808493I 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
-
WSamacs
AskWoody Lounger -
WSunkamunka
AskWoody LoungerApril 5, 2004 at 5:48 pm #809859 -
WSunkamunka
AskWoody LoungerApril 5, 2004 at 5:48 pm #809860 -
WSamacs
AskWoody Lounger -
WSunkamunka
AskWoody LoungerApril 2, 2004 at 1:43 am #808494I 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
-
WSamacs
AskWoody Lounger -
WSunkamunka
AskWoody Lounger -
joep517
AskWoody MVP -
WSamacs
AskWoody Lounger -
joep517
AskWoody MVP -
WSamacs
AskWoody Lounger -
WShlewton
AskWoody PlusApril 2, 2004 at 12:21 pm #808816I had a similar problem when I was still working at a company that had a network. My new computer had Windows 2000 on it and the one that was replaced had Windows 95. After many hours and a lot of failures it turned out that the passwords for my local drives and for the network drives were not being totally recognized by each other. Even though I always kept the passwords the same so I didn’t have so many to remember, it was a password synchronization problem. I don’t know what the network administrator eventually did to correct it but after about 2 months he did get it straightened out. In the meantime we moved all my database programs to my local drives and when someone else need them I gave them temporary access to a folder on my PC.
-
WShlewton
AskWoody PlusApril 2, 2004 at 12:21 pm #808823I had a similar problem when I was still working at a company that had a network. My new computer had Windows 2000 on it and the one that was replaced had Windows 95. After many hours and a lot of failures it turned out that the passwords for my local drives and for the network drives were not being totally recognized by each other. Even though I always kept the passwords the same so I didn’t have so many to remember, it was a password synchronization problem. I don’t know what the network administrator eventually did to correct it but after about 2 months he did get it straightened out. In the meantime we moved all my database programs to my local drives and when someone else need them I gave them temporary access to a folder on my PC.
-
joep517
AskWoody MVPApril 2, 2004 at 4:24 pm #808976Remember must be a LOCAL admin not a domain admin otherwise non-admin users will have problems. Why have Office XP and Access 97? Why not all XP? I doubt it is a good idea to have two versions of Office that different in age installed on the same PC. Much has changed in Office and the OS since Office 97 was released. All of the Office suite is much more integrated. There is so much more sharing of components that could be part of the problem.
Joe
--Joe
-
WSamacs
AskWoody LoungerApril 4, 2004 at 10:11 pm #809528 -
joep517
AskWoody MVPApril 5, 2004 at 1:55 am #809588 -
joep517
AskWoody MVPApril 5, 2004 at 1:55 am #809589 -
WSamacs
AskWoody LoungerApril 4, 2004 at 10:11 pm #809529 -
joep517
AskWoody MVPApril 2, 2004 at 4:24 pm #808977Remember must be a LOCAL admin not a domain admin otherwise non-admin users will have problems. Why have Office XP and Access 97? Why not all XP? I doubt it is a good idea to have two versions of Office that different in age installed on the same PC. Much has changed in Office and the OS since Office 97 was released. All of the Office suite is much more integrated. There is so much more sharing of components that could be part of the problem.
Joe
--Joe
-
WSamacs
AskWoody Lounger -
joep517
AskWoody MVP -
WSamacs
AskWoody Lounger -
WSamacs
AskWoody Lounger -
WSamacs
AskWoody Lounger -
joep517
AskWoody MVP
-
-
WSamacs
AskWoody Lounger -
WSamacs
AskWoody Lounger -
WSamacs
AskWoody Lounger
-
-
joep517
AskWoody MVP
-
-
WSamacs
AskWoody LoungerMarch 31, 2004 at 9:54 pm #807891The 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.
-
-
WBell
AskWoody_MVP -
WBell
AskWoody_MVP
Viewing 4 reply threads -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Auto Time Zone Adjustment
by
wadeer
1 hour, 43 minutes ago -
To download Win 11 Pro 23H2 ISO.
by
Eddieloh
6 hours, 56 minutes ago -
Manage your browsing experience with Edge
by
Mary Branscombe
7 hours, 34 minutes ago -
Fewer vulnerabilities, larger updates
by
Susan Bradley
1 hour, 28 minutes ago -
Hobbies — There’s free software for that!
by
Deanna McElveen
21 seconds ago -
Apps included with macOS
by
Will Fastie
2 hours, 39 minutes ago -
Xfinity home internet
by
MrJimPhelps
12 hours, 26 minutes ago -
Convert PowerPoint presentation to Impress
by
RetiredGeek
39 minutes ago -
Debian 12.11 released
by
Alex5723
22 hours, 52 minutes ago -
Microsoft: Troubleshoot problems updating Windows
by
Alex5723
1 day, 2 hours ago -
Woman Files for Divorce After ChatGPT “Reads” Husband’s Coffee Cup
by
Alex5723
5 hours, 59 minutes ago -
Moving fwd, Win 11 Pro,, which is best? Lenovo refurb
by
Deo
23 hours, 1 minute ago -
DBOS Advanced Network Analysis
by
Kathy Stevens
1 day, 19 hours ago -
Microsoft Edge Launching Automatically?
by
healeyinpa
1 day, 9 hours ago -
Google Chrome to block admin-level browser launches for better security
by
Alex5723
1 day, 22 hours ago -
iPhone SE2 Stolen Device Protection
by
Rick Corbett
1 day, 14 hours ago -
Some advice for managing my wireless internet gateway
by
LHiggins
21 hours, 57 minutes ago -
NO POWER IN KEYBOARD OR MOUSE
by
HE48AEEXX77WEN4Edbtm
14 hours, 49 minutes ago -
A CVE-MITRE-CISA-CNA Extravaganza
by
Nibbled To Death By Ducks
2 days, 7 hours ago -
Sometimes I wonder about these bots
by
Susan Bradley
2 days, 3 hours ago -
Does windows update component store “self heal”?
by
Mike Cross
1 day, 17 hours ago -
Windows 11 Insider Preview build 27858 released to Canary
by
joep517
2 days, 21 hours ago -
Pwn2Own Berlin 2025: Day One Results
by
Alex5723
1 day, 5 hours ago -
Windows 10 might repeatedly display the BitLocker recovery screen at startup
by
Susan Bradley
18 hours, 11 minutes ago -
Windows 11 Insider Preview Build 22631.5409 (23H2) released to Release Preview
by
joep517
3 days ago -
Windows 10 Build 19045.5912 (22H2) to Release Preview Channel
by
joep517
3 days ago -
Kevin Beaumont on Microsoft Recall
by
Susan Bradley
2 days, 12 hours ago -
The Surface Laptop Studio 2 is no longer being manufactured
by
Alex5723
3 days, 8 hours ago -
0Patch, where to begin
by
cassel23
3 days, 2 hours ago -
CFPB Quietly Kills Rule to Shield Americans From Data Brokers
by
Alex5723
3 days, 22 hours ago
Recent blog posts
Key Links
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.