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?