ALERT: Office Version 2204 may break Access applications

As a FYI, Microsoft has issued another update to current channel (Build 2204) which apparently contained changes that causes the otherwise functional Access application to stop work and throw errors. You may see the following error messages: * Property not found * No current record. * The search key [...]

2022-05-11T16:05:55-05:00May 11th, 2022|

Identifying and Managing Mission-Critical Access Applications During a Development Project

During your Access development project, it is important that you identify mission-critical Access applications. These are the Access databases that are crucial to the success of your project and your business as a whole. If these applications are not functioning properly and you have no idea how to [...]

2022-05-20T05:14:37-05:00May 6th, 2022|

6 Reasons Microsoft Access Can Help Your Business

Almost every business in the world uses Microsoft Excel. For creating simple spreadsheets, it’s probably the best piece of software in the world. But as a company grows and spreadsheets become more complicated, Excel will show its limitations. This is where Microsoft Access comes in. When your comp [...]

2022-04-19T03:46:49-05:00March 24th, 2022|

New Drivers For SQL Server… What You Need to Know

Recently, Microsoft released two new drivers for SQL Server, a major upgrade: ODBC 18 Driver for SQL Server OLEDB 19 Driver for SQL Server That's great news! However, there is a major breaking changes that requires your attention. Specifically, they changed how the default settings work for the encr [...]

2022-03-08T07:46:52-06:00March 7th, 2022|

*ALERT* Cannot open any more databases bug with Microsoft Office build 2201

Microsoft Office 365 Build 2201 Causes Access Applications to error We have received reports and confirmed with Microsoft there is an issue with Microsoft Office 365 build 2201 that causes Access applications to fail with errors usually at the startup but also during use. Because the update is now b [...]

2022-04-19T03:37:45-05:00February 7th, 2022|

*ALERT* Windows update breaks pure Access applications – fix available

We've gotten reports of an Office update adversely impacting existing applications that uses Access database to store data and is shared on a network location. Because of the update, people no longer can connect to same Access database file. With the update, only one can use the shared Access databa [...]

2022-05-06T09:02:04-05:00December 20th, 2021|

How does Access talk to ODBC data sources? Part 6

Effect of joins in a recordset In our sixth and final article of the ODBC tracing series, we are going to take a look at how Access will handle joins in Access queries. In the previous article, you saw how filters are handled by Access. Depending on the expression, Access may choose to parameterize [...]

2021-12-19T06:14:09-06:00December 20th, 2021|

How does Access talk to ODBC data sources? Part 5

Filtering the recordset In part 5 of our series, we will learn how Microsoft Access handles implemented filters and integrates them into ODBC queries. In the prior article, we saw how Access will formulate the SELECT statements in the ODBC SQL commands. We also saw in the previous article how Access [...]

2021-12-20T12:29:27-06:00December 19th, 2021|

How does Access talk to ODBC data sources? Part 4

What's Access doing when an user make changes to data on an ODBC linked table? Our ODBC tracing series continues, and in this fourth article we will explain how to insert and update a data record in a recordset, as well as the process of deleting a record. In the previous article, we learned how Acc [...]

2021-12-30T06:47:12-06:00December 18th, 2021|

How does Access talk to ODBC data sources? Part 3

Analyzing the key population query some more In part 3 of our ODBC tracing series, we are going to take a further insight into Access managing keys for ODBC linked tables and how it sorts and groups the SELECT queries together. In the previous article we learned how a dynaset-type recordset is in fa [...]

2021-12-19T23:16:25-06:00December 17th, 2021|
Go to Top