Professional Access Programmers - building and fixing databases.
We began our work in Denver with the Sherman Howard law firm. They needed an Expert Access developer with VBA Programming skills to modify their Access databases.
They then referred us to their client: Verizon. We then built a land management (for Cell Towers) Access database application for them.
We've consistently added more Access Database clients in the Denver area since these humble beginnings.
Here are some clients we have helped in Denver
Routt County Alcohol Council
The Council contacted us to upgrade their Access 97 database to the current version of Access. We have to first move the database into Access 2003, and then into Access 2019 (365). The was further complicated due to a workgroup information file protecting the Access 97 database and then advanced vba code that needed modification.
We are frustrated that Microsoft does not provide a transparent upgrade path from Access 97 directly to Access 365 (or whatever current version of Access is out today). We are further frustrated that Access discontinues support of features such as workgroup information files, pivot tables/report, Access Data Projects. So clients are forced to contact consultants like Data Control. We realize the importance of your database and the dilemma you are in. So we try to fairly price the upgrade to the new version of Access hoping that we can get future development work from you.
To get around the Workgroup Information File issue (the client had no documentation of this which is understandable considering the database is 20 years old and the original developer long gone), we opened a new Access 2003 database and imported all of the objects. This then allowed us to open the Access 2003 database in Access 2007 and perform the final upgrade steps.
This particular database uses advanced VBA code and expected the data file to be in a particular position on the server. If the data file wasn't there, the reports didn't work. So we searched through the code removing this requirement. We also had to modify a few of the libraries
Routt County Alcohol Board is a non-profit serving the city of Steam Boat in Colorado. Their database is a case management and reporting vehicle for their operations.
Partner to build Access databases for their Communications client Verizon Wireless in Denver Colorado.
This is a land use management for Verizon, tracking all of the land the wireless company owns.
Perry Partners, Inc
Build Microsoft Access Sales Contact Database with advanced search features for Real Estate Brokerage/Development firm in Denver Colorado
Verizon Wireless - Rockies
Real Estate Purchase tracking for cell phone towers. This database was built specifically for the Rocky Mountain division of Verizon for operations in Colorado, Nevada, Utah and Wyoming We provided the Free Microsoft Access quote for this project for this project. We then did the Access development as well.
Food and Drug Administration
Dynamics Edge had a contract to Train the Food and Drug Administration. When they had an Advanced Access Class to train, they called us as Expert Access Consultants to perform the training in Silver Spring, MD