Chicago, Illinois

We Love Chicago!

Ferrara Candy in Chicago asked us to take our Access Database: Plant Efficiency Tracking application and modify it into an Access Database / SQL Server: overall equipment efficiency application.

We work for other Access database clients in Chicago as well.

Thank you Wikipedia:
Located on the shores of freshwater Lake Michigan, Chicago was incorporated as a city in 1837 near a portage between the Great Lakes and the Mississippi River watershed and grew rapidly in the mid-19th century.[7] After the Great Chicago Fire of 1871, which destroyed several square miles and left more than 100,000 homeless, the city made a concerted effort to rebuild.[8] The construction boom accelerated population growth throughout the following decades, and by 1900, less than 30 years after the great fire, Chicago was the fifth-largest city in the world.[9] Chicago made noted contributions to urban planning and zoning standards, including new construction styles (including the Chicago School of architecture), the development of the City Beautiful Movement, and the steel-framed skyscraper.[10][11]

Our sister company: Data-Bolt.com PHP and MySQL developers and programmers for web applications: Data-blade.com

Specifc Access database expert solutions are here

We also build Access databases in Los Angeles California

>We also build Access databases in Houston Texas

Thank you Photographer for great picture!!!

Clients

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
B to B Solutions
Partner / Subcontract to build Access, SQL Server, .NET applications for their clients: Chemical Engineering client DuPont, their staffing client Apex Systems, Their health industry client Result Performance, and their insurance client Affinity Group Underwriters in Richmond, VA
WSI Web Strategies
Subcontract build Access & Web applications to Pack & Ride and Vatex and a Soccer Association. We subcontracted to WSI Web Strategies to help their clients. Both are in Richmond, Virginia

Virginia Association for Home Care and Hospice
Fixed and modifed an exiting Access database for an Association. This client manages their client invoicing and payments with an Access Database. They desired to share the database from home and work, so we migrated the data tables to a MySQL database in the cloud (Data Control Servers)
Dominion Partners
Dominion Partners desired an Access Guru to build an access database to manage their investment banking back office operations. They contracted us for this Access Database project.
Holiday Signs
Holiday Signs need an expert Access Database consultant to revise their Customer Relationship Manager application. This is an Access database that provides at-your-fingertip pipeline data to help both the salesmen and sales managers keep track of ongoing sales leads. Metrics come out of this database to help evaluate and improve sales performance.

We are also the PHP Developer and MySQL Consultant for Holiday signs. You may find more information about these services here: Data Bolt provides PHP and MySQL consulting

Greystone
Manufacturing Firm in Toano, Virginia.

We built a Quality tracking database that imports 1000s text files output from manufacturing machinery.

This microsoft access database reports defects during the manufacturing process for this automotive parts manufacturer

From Greystone website: Greystone is a global leader in the production of high volume precision machined and plated components for the automotive, aerospace, defense and industrial markets. Specializing in safety critical machining, hard chrome plating, and anodizing, we take pride in developing innovative engineering solutions to difficult problems.
HORWITZ, RICHARDSON & BAKER, LLC
Chicago Law Firm that used an Access database to manage their cases. We migrated their Access tables to MySQL tables in the cloud: Our Server.
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.