Top "Ms-access" questions

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

Ms Access Query: Concatenating Rows through a query

Suppose I have table in Ms Access with following information: ColumnA ColumnB 1 abc 1 pqr 1 xyz 2 efg 2 hij 3 asd My question …

sql ms-access group-by concatenation
Case expressions in Access

Can you use case expressions in Access? I'm trying to determine the max date form 2 columns but keep getting syntax …

sql ms-access
MS Access library for python

Is there a library for using MS Access database in python? The win32 module is not as easy as the …

python ms-access
Using left join and inner join in the same query

Below is my query using a left join that works as expected. What I want to do is add another …

sql ms-access left-join inner-join
Query Microsoft Access MDB Database using LINQ and C#

I have a *.MDB database file, and I am wondering if it is possible or recommended to work against it …

c# linq ms-access
Connecting a Microsoft Access Database to Java using JDBC and compiling

for a school database project we are making a database program (user GUI and the database). Using Microsoft Access 2010 I …

java ms-access jdbc database-connection executable-jar
Using MsgBox without pausing the application

I need to display a message to the user. When I do this using MsgBox, the program stops until the …

ms-access vba messagebox
Microsoft.ACE.OLEDB.12.0 Provider can no longer open .mdb under Windows 8

I have an x64 application which uses Microsoft.ACE.OLEDB.12.0 provider to read an MS Access Database on Windows 7 (x64) …

ms-access windows-8 64-bit oledb office-2013
create form to add records in multiple tables

I am new to access (I have only 2003 version) and I am getting crazy. Consider also that I am a …

ms-access ms-access-2003
How can I join two tables but only return rows that don't match?

I have two tables which look like this: T1: ID | Date | Hour | Interval T2: ID | Date | Hour I basically need …

sql ms-access join