Top "Ms-access-2007" questions

Microsoft Access 2007 - a rapid database application development tool

Meaning of MsysObjects values -32758, -32757 and 3 (Microsoft Access)

I'm quering the table MsysObjects for making a list of the objects in my database: SELECT MsysObjects.Name, MsysObjects.Type …

ms-access ms-access-2007
Access 2007: Unexpected error (40230)

I am getting an Unexpected error (40230) when trying to access VBA code for the form I have in Access 2007. I …

ms-access ms-access-2007 vba
How to remove row that exists in another table?

I have two tables. Main table is "CompleteEmailListJuly11" and the second table is "CurrentCustomersEmailJuly11". I want to delete rows in …

sql ms-access ms-access-2007
How do I compact and repair an ACCESS 2007 database by .NET code?

I need to compact and repair an Access 2007 .accdb database file. I know that JRO.JetEngine can do this with .…

database ms-access-2007 repair
"The data has been changed" error when stepping from main form into sub form

I'm migrating an Access database to SQL Server using the SQL Server Migration Assistant (SSMA). The Access application will continue …

ms-access vba odbc ms-access-2007
Using math functions in Sql with MS Access

I designed a query in SQL View using MS Access: select floor(num1) from t1; When I run it, I …

sql ms-access ms-access-2007 ms-jet-ace
Enabling and disabling controls on a Continuous Subform in Access 2007/2010

I need to enable or disable a control on a continuous subform, dependent on another field. The initial code I …

ms-access ms-access-2007 vba continuous-forms
Access 2007 Filter Subform Based On Field In Main Form?

I was tasked with creating a simple app to maintain a user's collectibles collection using Access 2007. There were some requests, …

ms-access parameters ms-access-2007 subform
Microsoft Access runtime error 2455 when trying to access grandchildren forms from child form

I have three forms in an Access 2003 database (developing in Access 2007) that sit in a parent -> child -&…

ms-access ms-access-2007 vba ms-access-2003 grandchild
Microsoft Access running out of temp space (Error 3183)

I inherited this Frankenstein application at work that utilizes an Access 2007 DB frontend with linked tables to an Oracle 10g …

oracle ms-access ms-access-2007 linked-tables