Click here to Skip to main content

Submit your article

MS-Access

MS-Access

Great Reads

Add some AI to your combo box lookups

by hector [.j.] rivas

Helping the combo box autocomplete function with a frequency count.

Advanced Classes in C

by Ghosuwa Wogomon

An example of a clean way to implement classes in C

Automating deployment for MS Access Application

by Mani Murthy

Using .Net application to automate the MS-Access Application

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

Latest Articles

Add some AI to your combo box lookups

by hector [.j.] rivas

Helping the combo box autocomplete function with a frequency count.

Advanced Classes in C

by Ghosuwa Wogomon

An example of a clean way to implement classes in C

Automating deployment for MS Access Application

by Mani Murthy

Using .Net application to automate the MS-Access Application

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

All Articles

MS-Access

Copy data from all tables in Access 2003

by KumarM.NET

How to copy data from all tables in Access 2003.

DataTable Merge Performance

by Alexandros Pappas

This project measures performance of the DataTable.Merge method.

Deleting protected folders in Windows 7

by Pascal Ganaye

Deleting protected folders in Windows 7

Enumerate File System Getting Past UnauthorizedAccessExceptions

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.

Export data from SQL Server to MS Access

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.

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

by Mike Baldini

The following code filters the specified database

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

Microsoft Access Database Engine 2010 Redistributable

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.

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

OLEDB Provider is Not Registered on the Local Machine

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.

Pure SQL solution to Database Table Paging

by DrABELL

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

Query to get the object information a database in Microsoft Access

by Vivek.Net

Query to get the object information a database in Microsoft Access

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.

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

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.

Use SQL to generate large data sequence

by DrABELL

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