DCount Function

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. You can use the DCount function to determine the number of records that are in a specified set of records (a domain). Use the DCount function in a Visual Basic for Applications (VBA) module, a macro, a query expression, or a calculated control. For example, you could use the DCount function inContinue reading “DCount Function”

Add staff to your booking calendar in Microsoft Teams

You’ll seek to add all people who conduct appointments to your booking calendar, alongside anyone who aids with scheduling tasks. Choose Add Staff from the upper right side of the app. Input a name or e-mail address, choose an exact match, and tap Add. Pick a role from the drop-down adjacent to the staff name. Every role isContinue reading “Add staff to your booking calendar in Microsoft Teams”

Rediscovered JET and ODBC whitepapers

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. The other day, we were scrambling through the Access vaults and happened to stumble upon rediscovered assorted JET and ODBC whitepapers of classic variety. Despite their edges being frayed, pages appearing yellowed, and the ink being faded, they were still explicitly legible. When adequateContinue reading “Rediscovered JET and ODBC whitepapers”

ODBC Scalar Functions

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Microsoft Access SQL advocates the use of the ODBC specified syntax for scalar functions in a pass-through query that functions on Microsoft SQL Server. For example, to garner all rows where the absolute value of the volatility in the stock price was greater than five, apply the followingContinue reading “ODBC Scalar Functions”

Administer ODBC data sources

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010 Access 2007. Open Database Connectivity (ODBC) is a protocol that you can apply to connect a Microsoft Access database to an external data source like Microsoft SQL Server. This article has background information about ODBC data sources, how to make them, and how to connectContinue reading “Administer ODBC data sources”

Using the Large Number data type

Applies to: Access for Microsoft 365, Access 2019, Access 2016. The Large Number data type stores a non-monetary, numeric value and is compatible with the SQL_BIGINT data type in ODBC. Use this data type to efficiently calculate large numbers. You can add it as a field to an Access table. You can also link to or importContinue reading “Using the Large Number data type”

Comparing Access SQL with SQL Server TSQL

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010. If you migrate your Access data to SQL Server or you design an Access solution with SQL Server as the back-end database, it’s crucial that you understand the distinctions between Access SQL and SQL Server Transact SQL (TSQL). In this article, the significant differences youContinue reading “Comparing Access SQL with SQL Server TSQL”

Comparing Access and SQL Server data types

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Access data types are distinctly labelled from SQL Server data types. For example, a SQL Server column of the bit data type is imported or linked into Access with the Yes/No data type. The below table evaluates both SQL Server and Access data types. SQL Server data typeContinue reading “Comparing Access and SQL Server data types”

Take an Access excursion through SQL Server

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010. Once you have migrated your data from Access to SQL Server, you now have a client/server database, which may be an on-premises or a hybrid Azure cloud solution. Either way, Access is now the presentation layer and SQL Server is the data layer. Now isContinue reading “Take an Access excursion through SQL Server”

Create a pass-through query

Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010. With Access, you can utilise this as a front-end application and go on to link to tables in a back-end server, like SQL Server. Automatically, many queries operate locally in the Access ACE database engine. For some situations, Access can perform a query independently on SQL Server,Continue reading “Create a pass-through query”