by Neil Gordon (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 3.0
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: 
(3 Votes)
A Visual Basic application development framework for Microsoft Great Plains (Dynamics and EEnterprise) accounting software. This application runs completely independant to Great Plains. (If you require seamless integration consider using Dexterity and/or VBA). The initial version allows a user to login to the system, and select a company.
The project has also been registered on www.sourceforge.net as open source (search for Great Plains). The idea is to build up a library of code and accelerate application development.
Included is a sample program to copy security settings from one user to another. (Be sure to read the readme.txt before using this program!)
Assumes
VB is more accessible than Dexterity, so there are advantages to developing in VB.
The disadvantage of doing things this way is that the resulting application runs external to Great Plains.
The class module is intended to store all general logic relating to the program. The intention is to allow reusability of code, and to build
up a library of code with which to create Great Plains apps.
The system setup file and the user file are both stored as custom recordsets on the disk. This avoids the chicken and egg scenario when accessing the target SQL database.
There is a basic encryption algorithm on the password. This would have to be enhanced and the source code hidden for effective security.
The system looks up users from Great Plains, but since we do not have the algorithm for Great Plains passwords we have to store our own.
If you run into any problems not being able to login to the system, first delete the wrapper.dat and wrapper1.dat files. The program will then prompt for new setup information.
This program was tested with EEnterprise Version 6 running on SQL 2000.
VBcodersUpload