Microsoft Access

MS-Access

Great Reads

Exploring Computational Number Theory (Part 1)

by William Hey

Classical number theories

Dynamically Add Access Database Columns at Runtime using VB.NET

by Rob Culhane

How to dynamically add access database columns at runtime using VB.NET

Semi-Prime Ordered Sequences (Part 2)

by William Hey

Semi-Prime Ordered Sequences (Part 2) is the follow-on to “Exploring Computational Number Theory (Part 1)” and describes a process for ordering the semi-prime base sequences.

Selecting and Importing Excel File and Sheet for import into Access

by Clifford Nelson

This is a tip that has the code for selecting an Excel file and sheet for import into Microsoft Access. This includes the code required to browse for a file, and populate a ListBox with the sheets of the Excel Workbook, and the code to import an Excel spreadsheet.

Latest Articles

Azure Active Directory Authentication with OpenID Connect and Authorization with App Roles

by DotNetLead.com

Azure AD for authentication and authorization of users for your website

Indian Number Formatting of Currency in Microsoft Access and Excel

by Gustav Brock

Format amounts in VBA using the Indian number format for currency and amounts

Migrating Legacy Microsoft Access Database to Excel (or any other database) - Complete Application and Code

by rohitsies

Helps migrate your Microsoft Access database to Excel

Method to Change Source of a Form’s Subform Source to a Query or Table in Microsoft Access

by Clifford Nelson

Method to change source of a Form’s Subform source to a Query or Table in Microsoft Access

All Articles

top

Microsoft Access

Selecting and Importing Excel File and Sheet for import into Access

7 Sep 2018 by Clifford Nelson

VB6

VBA

MS-Excel

Microsoft

MS-Access

Use SQL to generate large data sequence

19 Feb 2015 by DrABELL

Generate large data series by using Cartesian Product and small data table

Updating Auto-Numbered Primary Keys in a DataTable (MSAccess Databases)

3 Oct 2011 by Adam Covitch

It is common to configure back-end database tables to contain a column with an auto-generated ID unique to each row. This tip describes how to sync the ID generated by the database back to the application layer.

DataTable

MS-Access

DataTable Merge Performance

1 Jul 2013 by Alexandros Pappas

This project measures performance of the DataTable.Merge method.

Pure SQL solution to Database Table Paging

15 Aug 2012 by DrABELL

Portable solution encapsulated in single SQL query allows to select N rows offsetting M records

Copy data from all tables in Access 2003

1 Jul 2013 by KumarM.NET

How to copy data from all tables in Access 2003.

.NET

Office

MS-Access

Method to Change Source of a Form’s Subform Source to a Query or Table in Microsoft Access

12 Sep 2018 by Clifford Nelson

Method to change source of a Form’s Subform source to a Query or Table in Microsoft Access

Query to get the object information a database in Microsoft Access

21 Feb 2011 by Vivek.Net

Query to get the object information a database in Microsoft Access

MS-Access

Enumerate File System Getting Past UnauthorizedAccessExceptions

21 Jul 2014 by Brad Joss

Search for files and folders and don't exit the search when there is an error accessing a protected folder, just skip it.

OLEDB Provider is Not Registered on the Local Machine

8 Jul 2012 by Shemeer NS

Solution for Exception: The 'Microsoft.ACE.OLEDB.12.0' 'Microsoft.Jet.oledb.4.0' provider is not registered on the local machine.

ADO.NET

ASP.NET

MS-Access

Help for the Access 2000-2003 developer with 'Out of Memory' issues or problematic codebase

24 Dec 2010 by Mike Baldini

The following code filters the specified database

VBA

Office

MS-Access

Migrating Legacy Microsoft Access Database to Excel (or any other database) - Complete Application and Code

1 Jun 2020 by rohitsies

Helps migrate your Microsoft Access database to Excel

Microsoft Access Database Engine 2010 Redistributable

21 Apr 2012 by Member 8770718

If as a developer you have a 32-bit application using this OLEDB provider on a machine with a 64-bit installation of Office 2010, you’ll need to install the 32-bit version of the provider.

Dev

DBA

MS-Access

Export data from SQL Server to MS Access

18 Oct 2011 by Muhammad Shahid Farooq

The purpose of this article is to provide a fast but easy way to export data from SQL Server to MS Access.

SQL-Server

MS-Access