Solved
May 24, 2010
How to determine Jet database Engine Type programmatically
I have a program which needs to upgrade any Access (Jet) database it opens to JET Version4.x if it isn't already that version. (This…
thumb_up 4
trending_up 10
Access VBA
<p>Relational database design, SQL integration, and form logic.</p>
Solved
May 15, 2010
Passing a parameter in a Report’s Open Event to a parameter query (Access 2007)
I would like to know if there is a way to set the parameters in an Access 2007 query using VBA. I am new…
thumb_up 7
trending_up 4
Solved
February 3, 2010
Insert record into table if entry does not exist in another table- with an extra twist
Hi to all you mighty SQLsuperheros out there.. Can anyone rescue me from imminent disaster and ruin? I'm working with Microsoft Access SQL. I'd…
thumb_up 13
trending_up 13
Solved
December 22, 2009
XML vs. SQlite vs. Access
Question: We've started a project for a customer, which includes what would normally be done with a database. However, the customer wants no database…
thumb_up 8
trending_up 5
Solved
December 8, 2009
Forcing a datatype in MS Access make table query
I have a query in MS Access which creates a table from two subqueries. For two of the columns being created, I'm dividing one…
thumb_up 8
trending_up 5
Solved
November 16, 2009
MS Access: Linked Tables – how to get the connection string when linked table manager is not installed
I'm looking after a database while its author is on holiday. The server it's running on has no linked table manager, and the db…
thumb_up 10
trending_up 4
Solved
November 9, 2009
Access SQL query: find the row with the most recent date for each distinct entry in a table
All, I'm sure this is a pretty simple SQL query question, but I'm sure there's a good way, and a very BAD way, to…
thumb_up 6
trending_up 5
Solved
October 15, 2009
MS Access Rounding Precision With Group By
Why doesn't the average of the score of an employee of each month, when summed, equal the average of the employees score (ever)? Average…
thumb_up 7
trending_up 5
Solved
October 5, 2009
MS Access error “ODBC–call failed. Invalid character value for cast specification (#0)”
Does anyone have an idea what this error means or how to solve it? I am using Access 2003 and SQL2005. It comes up…
thumb_up 6
trending_up 5
Solved
September 25, 2009
OleDbCommand parameters order and priority
I have been debugging this query for the last 40 minutes, and the problem apparently is the order of the parameters after all. SELECT…
thumb_up 28
trending_up 13