Comeau Software Solutions

Making sense of technology since 2000.

Menu
  • Home / Updates
  • Services / Contact Us
  • Rogue C# Project Page
  • More Resources
    • Join Ocala’s Tech Community!
    • YouTube Channel
    • Personal Site
Menu

Category: Databases

Connecting Microsoft Access to MySQL

Posted on July 3, 2022August 8, 2022 by Andrew Comeau

In my latest video, I demonstrate how to use Microsoft Access as a front-end for MySQL without having to create a DSN entry on the client machine. Access easily connects to MySQL through an ODBC connection but the standard practice is to create a dedicated data source under the ODBC Data Sources Administration panel in…

Read more

New Video – Learning SQL with SQLite

Posted on June 14, 2021July 28, 2021 by Andrew Comeau

An essential skill … If there is one programming language that I would recommend for everyone, it’s Structured Query Language (SQL). SQL (often pronounced “sequel”) is the main language used to communicate with databases including Oracle, SQL Server and Microsoft Access. It’s the set of commands used to write and retrieve data. If you work…

Read more

Splitting a Database in Microsoft Access

Posted on March 23, 2021January 4, 2023 by Andrew Comeau

My latest video shows how to split a database in Microsoft Access to separate the data from the user interface and programming elements. Access can link to data from different file formats including Excel, text files and other Access databases. For multi-user applications, you can have an Access file with just the forms, reports, queries…

Read more

How to Shut Down Remote Instances of Microsoft Access

Posted on November 6, 2019February 18, 2023 by Andrew Comeau

When you’re managing a multi-user Microsoft Access application, there are times when you need all users out of the database so that you can make changes to table structures and other items. Asking everyone to shut down is unreliable and using the Windows Task Manager to forcibly shut down instances of Microsoft Access is risky…

Read more

Managing Your Organization’s Contacts with CiviCRM

Posted on September 14, 2019November 18, 2022 by Andrew Comeau

Whether you’re selling products, managing a non-profit or running a political campaign, one of the most important things you do is to manage relationships with other people. Your ability to maintain your organization’s contact database, whether it contains potential customers or donors, is essential to your operations. Many organizations use various types of Contact Relationship…

Read more

Things I Learned About CiviCRM This Week

Posted on September 8, 2019November 18, 2022 by Andrew Comeau

I was introduced to CiviCRM a few years ago when a new customer needed a replacement for an old poorly designed database solution and needed it quickly. After getting quotes starting at $10,000 for systems supposedly designed for non-profits, I stumbled on CiviCRM which was free, open source and seemed to have a good community…

Read more

ComeauSoftware.com provides learning resources, including tutorials and videos, to guide you in understanding today's technology. Please check out our YouTube channel and bookmark this site to stay informed of upcoming projects.

Comeau Software Solutions also provides software consultation, including the development of database solutions, in Ocala, Florida. This includes rescuing Microsoft Access database projects and assistance in move to other solutions. Please contact us for more information on how we can help you with your project needs.

Available on Amazon.com


Starting Out with Programming Logic and Design 6th Edition


Tony Gaddis
  • Articles
  • C#
  • Careers
  • Commentary
  • Database Design
  • Databases
  • Hardware
  • How-to
  • Humor
  • Internet
  • Jobs
  • Linux
  • Microsoft Access
  • MySQL
  • Ocala I.T. Professionals
  • Personal
  • Personal Tech
  • Programming
  • Resources
  • Reviews
  • Rogue C# Series
  • Software
  • SQL
  • Uncategorized
  • Web Design
  • Writing
©2023 Comeau Software Solutions | Theme by SuperbThemes