Top "Ms-access" questions

Microsoft Access, also known as Microsoft Office Access, is an application development and database development tool from Microsoft.

Find the directory part (minus the filename) of a full path in access 97

For various reasons, I'm stuck in Access 97 and need to get only the path part of a full pathname. For …

vba ms-access excel ms-access-97
How to find longest string in the table column data

I've a table contains the columns like Prefix | CR ---------------------------------------- g | ;#WR_1;#WR_2;#WR_3;#WR_4;# v | ;#WR_3;#WR_4;# j | WR_2 …

sql ms-access
The action or event has been blocked by Disabled Mode

I am using Microsoft Access 2007 to move and massage some data between two SQL Servers. Yesterday everything was working correctly, …

ms-access ms-access-2007
How to connect PHP with Microsoft Access database

I am currently faced with a new challenge to develop a site using Microsoft Access as the primary database instead …

php ms-access odbc
how to use distinct in ms access

I have two tables. Task and Categories. TaskID is not a primary key as there are duplicate values.When there …

sql ms-access distinct ms-access-2003
How to refresh linked tables in an Access mdb when ODBC changes

I can create an Access mdb and add a linked table to an Sql Server database via ODBC. If I …

ms-access odbc
How to connect to a MS Access file (mdb) using C#?

I'm trying to connect to a mdb file and I understand that I would need Microsoft.OLEDB.JET.4.0 data provider. …

c# ms-access oledb
Insert SQL command with Datetime in MS-Access

I am trying the following query in MS-Access 2007, but it fails on the time field. INSERT INTO LOG ( EMPLOYEECODE, STATUSID, …

ms-access ms-access-2007
The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine while data export to MS ACCESS

I am beginner in using Microsft.ACE.OLEDB 12.0. I create a Winforms application VS 2010. And create a function for export …

c# winforms ms-access office-2007 winforms-interop
Progress bar in MS Access

I have a query running in Microsoft Access 2010 and it takes over 30 minutes to run normally. I would like to …

vba ms-access