It is possible to do a little with VBA. For example, here is a start on creating script for a database with local tables. Dim db As Database Dim tdf As TableDef Dim fld As DAO.Field Dim ndx As DAO.Index Dim strSQL As String Dim strFlds As String Dim strCn As String Dim fs, f … Read more
The results from your query are wrong because the values you are trying to summarize are being grouped, which causes duplicate values to be included in the SUM. You could solve it with a couple of sub-selects: SELECT AP1.[PROJECT], (SELECT SUM(AP2.Value) FROM AP AS AP2 WHERE AP2.PROJECT = AP1.PROJECT) AS SUM_AP, (SELECT SUM(INV2.Value) FROM INV … Read more
This is an old question, but nobody has ever actually answered it. Here are the questions: How are concurrent reads handled in MDB? How are concurrent updates/deletes handled in MDB? Is there a concept of locks and how can I leverage it in a .NET app? Is placing the MDB file on a network share … Read more
The straight answer is that the behaviour of the wildcard characters is dependent on the ANSI Query Mode of the interface being used. ANSI-89 Query Mode (‘traditional mode’) uses the * character, ANSI-92 Query Mode (‘SQL Server compatibility mode’) uses the % character. These modes are specific to ACE/Jet and bear only a passing resemblance … Read more