Top "Ms-access" questions

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

A select query selecting a select statement

I don't even know if I am doing this query the right way. There is a Sandwiches table that has …

sql ms-access select ms-access-2007
How do I count unique items in field in Access query?

My Table: table1 ID Name Family 1 A AA 2 B BB 3 A AB 4 D DD 5 E EE 6 A AC SQL command …

sql ms-access
Show "Open File" Dialog

How would I go about showing an open file (or file select) dialog in access 2007 VBA? I have tried using …

vba ms-access
java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?

I have created an MS Access database and assigned a DSN to it. I want to access it through my …

java ms-access jdbc jdbc-odbc
How to open a folder in Windows Explorer from VBA?

I want to click a button on my access form that opens a folder in Windows Explorer. Is there any …

ms-access vba
SQL Query - Using Order By in UNION

How can one programmatically sort a union query when pulling data from two tables? For example, SELECT table1.field1 FROM …

sql ms-access sorting sql-order-by union
"Operation must use an updateable query" error in MS Access

I am getting an error message: "Operation must use an updateable query" when I try to run my SQL. From …

ms-access
How to select top 10 in Access query?

My Access database table has 2 columns: name and price. I want to do a query that select the top 10 highest …

ms-access
How do I test if a recordSet is empty? isNull?

How can you test if a record set is empty? Dim temp_rst1 As Recordset Dim temp_rst2 As Recordset …

ms-access vba
Manipulating an Access database from Java without ODBC

I want to manipulate a Microsoft Access database (.accdb or .mdb file) from my Java project. I don't want to …

java ms-access ucanaccess