Solved

My new VB 6 application doesn't work for non Administrtor user accounts

Posted on 2007-11-14
6
280 Views
Last Modified: 2013-11-14
Ive written an application using Visual Basic 6.0 SP6.  The application uses an Access 2003 data base.  I then created an install package using Visual Studio Installer 6.0.   When the application is installed and used by a user with administrator permissions, everything runs fine.  When a different user (power user) on the same PC logs on (without Administrative permissions), no data is displayed in any of the data fields.  The one exception is that the ADO data control displays the number of records in the record set, which indicates that my program is successfully accessing the data base.  I'm using Windows XP Pro.

If I give the end user administrator permissions, everything then works. Also, when logged in as a power user without administrator permissions and you right click the executable file and click Run as and give an administrator user name and password, everything works.

Can anyone tell me why the end user account doesnt display any data but the administrator account works fine?  
0
Comment
Question by:RiverGuy59
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 9

Expert Comment

by:ajkamp
ID: 20284601
Where did you put the Access DB? If the user doesn't have read/write/modify permissions on the folder/drive Access won't work correctly.
0
 

Author Comment

by:RiverGuy59
ID: 20285732
The Access DB is placed in the same folder as the application by default.  It does have read/write/modify permissions.
0
 
LVL 18

Accepted Solution

by:
mdougan earned 500 total points
ID: 20290548
I know that I faced similar problems a long time back.  What I did was open up the Local Security Settings on the computer and compared what priviliges Administrator had that Authenticated Users did not have, and one at a time, I would enable the privilige for Authenticated Users, then try the application.  Make a note of each one you enable as you go along.  If enabling a permission didn't make  your application work, don't undo it yet, just make a note of that and keep going until your application works, or, you've enabled all permissions that Administrator has (if it still doesn't work then undo everything you set and look for another solution).

If you change a permission and your app starts to work, then start at the first permission you changed and start removing the permissions.  If suddenly it stops working, re-enable that permission and move on to the next one.  In the end, you may have found one or more permissions that are necessary for your app to work.

Some permissions shouldn't have any impact, and should be pretty obvious, such as "Shut down the system from a remote computer".  But, if you want to be thorough, go through them all.

I vaguely remember my problem involved the Create Global Object permission or maybe Impersonate a client after Authentication.
0
 

Author Comment

by:RiverGuy59
ID: 20291315
Thanks mdougan,

I'm on the road today but will give this a try tomorrow.
0
 
LVL 1

Expert Comment

by:Computer101
ID: 20632830
Forced accept.

Computer101
EE Admin
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month10 days, 5 hours left to enroll

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question