Top "Ms-access-2007" questions

Microsoft Access 2007 - a rapid database application development tool

How to show row number in Access query like ROW_NUMBER in SQL

I have a table in Microsoft Access, and I want to show row number in a column using a select …

ms-access-2007 row-number
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.

every thing work fine locally but this error occurs when I publish it: The 'Microsoft.ACE.OLEDB.12.0' provider is …

c# asp.net web-config ms-access-2007
How to disable access security notice "A Potential security concern has been identified"

i have a shared access application, i created an accde file for 32-bit machine, when user open the application he/…

vba security ms-access ms-access-2010 ms-access-2007
How to populate the value of a Text Box based on the value in a Combo Box in MS Access 2007?

I have a combo box which is of a lookup type, i.e., I've selected the source to be a …

forms ms-access combobox ms-access-2007
Getting Combobox.Value in Access VBA

I have this code: If Me.Combobox.Value = "My Text" Then As I want to test if "My Text" is …

ms-access vba combobox ms-access-2007
Save password for ODBC connection to MS SQL server from MS Access 2007

I am in charge for migrating old Access 2007 project to MS SQL server 2008 Express. The first stage is to move …

ms-access odbc ms-access-2007 sql-server-2008-express
MS Access call SQL Server stored procedure

I have an MS Access application that contains all tables linked to SQL Server, so in MS Access VBA code …

sql-server vba ms-access stored-procedures ms-access-2007
How to insert "Entire" DAO recordset into a table with VBA

I have a DAO recordset that gets created fine and I can transfer the records from the set to a …

ms-access ms-access-2007 vba dao
cycling through values in a MS Access list box

I have a list box that populates with different sets of data based on user selections. How can I cycle …

vba ms-access ms-access-2007