Solved
January 20, 2014
No read permission on MSysObject error
I am trying to connect to an MS Access database (.mdb) through OleDb. My query is SELECT * FROM ListQueries which fetches me the…
thumb_up 8
trending_up 5
ms-access
55 expert-verified Q&A posts in this category, sourced from the top-voted answers on Stack Overflow.
Solved
October 31, 2013
VS 2012.3 Referencing MS Access COM DLL, could not resolve COM reference error
I created a new Console project in VS2012.3 (32bit exe) and added a COM Type Library reference to Microsoft Access (I tried both 2003…
thumb_up 7
trending_up 4
Solved
October 24, 2013
Access SQL syntax error when using OleDbCommandBuilder
I am going to INSERT data in Access Database using OleDbDataAdapter in C# but i got an error with message Syntax Error in INSERT…
thumb_up 10
trending_up 3
Solved
October 17, 2013
MS-Access – you tried to execute a query that does not include the specified aggregate function
SELECT SUM(orders.quantity) AS num, fName, surname FROM author INNER JOIN book ON author.aID = book.authorID; I keep getting the error message: "you tried to…
thumb_up 17
trending_up 9
Solved
July 3, 2013
Trouble writing to database in C# WinForm Application
I'm relatively inexperienced with professional programming, but I'm trying to write a program that interfaces with a MS Access Database. Essentially I'm gathering information…
thumb_up 7
trending_up 3
Solved
June 24, 2013
Row numbers in query result using Microsoft Access
I always use this query in sql server to get Row number in a table: SELECT * FROM (SELECT *, Row_number() OVER( ORDER BY…
thumb_up 8
trending_up 5
Solved
May 30, 2013
what is the alternative to NVL function in MS Access 2007
I wrote an SQL query in MS Access select NVL(count(re.rule_status),0) from validation_result re, validation_rules ru where re.cycle_nbr="+cycle_nbr+" and…
thumb_up 7
trending_up 6
Solved
May 20, 2013
C# AND ACCESS – Data type mismatch in criteria expression
I've created a code that updates/edits details of a/an computer/electronic product for a C# program connecting to the MS Access. Here are the codes:…
thumb_up 10
trending_up 2
Solved
December 31, 2012
SQL LIKE operator with parameters and wildcards
I have a query where I want to return all Clients that have a certain string in the name with wildcards on either side.…
thumb_up 5
trending_up 6
Solved
November 29, 2012
Wrong number of arguments with SQL ISNULL() on Access DB
I have this query in VB application on Access DB: SELECT DISTINCT Specialization, MAX(a.faultZone) AS faultZone, ISNULL(a.faultCount, 0) AS NoOfFaults FROM Technicians AS t…
thumb_up 7
trending_up 5