Top "Ms-access" questions

Does MS Access support "CASE WHEN" clause if connect with ODBC?

Does ODBC support CASE WHEN clause for MS Access? Is there any other database which does not support the CASE …

sql database ms-access odbc

How to open Form in Add record

I have a form to input records to a table. I would like it to open on an empty add (…

ms-access ms-access-2010

Is there an equivalent to the SUBSTRING function in MS Access SQL?

I want to do something like this within an MS Access query, but SUBSTRING is an undefined function. SELECT DISTINCT …

ms-access

Autonumber value of last inserted row - MS Access / VBA

I have a JET table with an auto-number as the primary key, and I would like to know how I …

ms-access vba jet

Maximum number of rows in an MS Access database engine table?

We know the MS Access database engine is 'throttled' to allow a maximum file size of 2GB (or perhaps internally …

ms-access jet ms-jet-ace

JDBC ODBC Driver Connection

I'm currently working on a project for a class at my University. I am learning about connecting and manipulating databases …

java macos ms-access jdbc jdbc-odbc

Access 2013 - Cannot open a database created with a previous version of your application

I have an Access database created more than 10 yrs back. I have very important data in it & I think …

ms-access ms-access-2013

Using Excel VBA to export data to MS Access table

I am currently using following code to export data from worksheet to MS Access database, the code is looping through …

sql excel ms-access vba

Does VBA contain a comment block syntax?

In VBA is there a short way to comment out a block of code the same way java uses /*...*/?

excel vba ms-access outlook word

Multiple INNER JOIN SQL ACCESS

Syntax Error (missing Operator) in query expression 'tbl_employee.emp_id = tbl_netpay.emp_id INNER JOIN tbl_gross ON …

sql ms-access join inner-join