Differences

This shows you the differences between two versions of the page.

--- projects:microsoftaccessandjava [2010/12/26 10:04] – rlunaro
+++ projects:microsoftaccessandjava [2022/12/02 21:02] (current) – external edit 127.0.0.1
@@ Line 2: / Line 2: @@
 ===== Background =====
+I have tons of msAccess databases, each of one runs a query. All of the queries are action queries, i.e. queries that dump its results into a new table, that must be erased each time.
+I need to run all the queries in an ordered manner (some queries depend on others and so on..), so I quickly thought on an updating application that should be done in order to achieve the task.
+For this task, and because I am orienting muy development skills through Java, I want to try to do this in java.
+Let's see if it possible.
+===== Result of the project =====
+**Failed:** it is not possible to run an action query from java. Nor to execute a select * into table from query it is possible, because the new table appears empty (¿due to security constraints???).
+**Pending:** to try it with access 2007, just to check if this will work in a newer database version. But I suspect that there is no difference.
@@ Line 14: / Line 29: @@
 The sql engine of access is called Jet SQL. Here is a manual:
-http://www.devguru.com/technologies/jetsql/quickref/jet_sql_intro.html
+http://www.devguru.com/technologies/jetsql/home
+{{:projects:jet_database_engine_reference_manual.odt|Download a manual taken from Microsoft website}}
+There is the manual online:
+  * [[http://technet.microsoft.com/en-us/library/cc966378.aspx]]