Top "Ms-access" questions

Error: "Could Not Find Installable ISAM"

I've written some VBA code in an Excel workbook to retrieve data from an Access database in the same directory …

excel ms-access vba connection-string

Export tables to an excel spreadsheet in same directory

I have two tables in my access database that I want to be able to export to excel. I can …

excel vba ms-access export-to-excel

How can I modify a saved Microsoft Access 2007 or 2010 Import Specification?

Does anyone know how to modify an existing import specification in Microsoft Access 2007 or 2010? In older versions there used to …

ms-access

How to copy to clipboard using Access/VBA?

Using VBA inside Access2003/2007. How to copy the contents of a string variable to the clipboard? This site recommends a …

windows ms-access clipboard vba

How can I convert an MDB (Access) file to MySQL (or plain SQL file)?

Is it possible to create a Dump of SQL commands from a Microsoft Access database? I hope to convert this …

mysql sql ms-access import dump

How to create a new column in a select query

In MS Access, I want to insert a new column into the returned result of a select query. The new …

sql ms-access select insert

Operation must use an updatable query. (Error 3073) Microsoft Access

On some Microsoft Access queries, I get the following message: Operation must use an updatable query. (Error 3073). I work around …

ms-access

How to insert values into the database table using VBA in MS access

I've started to use access recently. I am trying to insert a few rows into the database; however, I am …

sql ms-access vba ms-access-2010

Good Free Alternative To MS Access

Consider the need to develop a lightweight desktop DB application on the Microsoft platforms. It could be done fairly easily …

database ms-access desktop

What is the equivalent of Select Case in Access SQL?

I have a query which includes fields named openingbalance and commissions. I would like to compute values for commissions based …

ms-access select-case