Solved

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

Posted on 2007-11-14
6
218 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
6 Comments
 
LVL 9

Expert Comment

by:ajkamp
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Thanks mdougan,

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

Expert Comment

by:Computer101
Comment Utility
Forced accept.

Computer101
EE Admin
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now