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: Microsoft Access

FREE Course – Managing Your Data with MS-Access

Posted on January 23, 2023February 18, 2023 by Andrew Comeau

In early 2020, I created the online course Managing Your Data with Microsoft Access which showed how to create an entire Access application from start to finish. This course has over 5 1/2 hours of video instructions covering the creation of tables, forms and reports along with specialty topics like printing Dymo labels from Access….

Read more

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

Filtering Combo Boxes in Microsoft Access

Posted on February 1, 2022February 18, 2023 by Andrew Comeau

Combo boxes are extremely useful in Microsoft Access and other design environments. They provide a compact control from which your users can access a drop-down menu that enables them to choose from a variety of options. In my applications, combo boxes often pull their rows from lookup tables such as product or customer lists and…

Read more

Customizing Reports in Microsoft Access

Posted on May 25, 2021January 4, 2023 by Andrew Comeau

In my latest video, I go into more detail about Microsoft Access report settings. This video is also an addition to my tutorial series, Managing Your Data with Microsoft Access which is now free on YouTube. Microsoft Access has always been known for having a great report designer with which you can put together professional…

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

Online Course – Managing Your Data with Microsoft Access

Posted on March 17, 2020January 4, 2023 by Andrew Comeau

One of the things I hear about Microsoft Access is that it’s simply too complicated for many people to work with. This is because Access is designed for building database applications that can be used to automate and manage processes. Too few resources approach it from that perspective. This leaves users and students without the…

Read more

Recovering a Corrupted Table in Access With VBA

Posted on November 16, 2019December 2, 2019 by Andrew Comeau

Recently, a client started experiencing errors, seemingly at random, in the database application I managed for them. The errors immediately started mentioning corruption and then these came through … Error 3167 – Record is Deleted Getting everyone out of the system and running a Compact / Repair seemed to help, but then … “The Microsoft…

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

Troubleshooting MS-Access Error 31532 – Unable to export data.

Posted on September 11, 2019February 18, 2023 by Andrew Comeau

Microsoft Access can sometimes seem to have its own obstinate personality, throwing errors that persist no matter what you try. I wanted to share a recent troubleshooting experience to show some of the steps that you can take when a function is just not working as expected and the decision process involved in fixing it.

Read more

Deploying MS-Access Table Design Changes to Remote Files

Posted on August 7, 2019February 18, 2023 by Andrew Comeau

A New Challenge for Access I designed a Microsoft Access database for one of my clients and it’s split into two files – a front-end file with all the forms, reports and code and a back-end file with the tables. That’s pretty standard. During the development process, I needed to make adjustments to the table…

Read more
  • 1
  • 2
  • 3
  • Next

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


Apple AirTag
Easily find your items and devices with the iPhone app or Siri. Find lost items over Apple's anonymous and encrypted Find My network. Long-lasting lithium battery.
Apple

  • 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