~~DISCUSSION:off~~
======MS Access======
Einige Kurztips

===== Kleinigkeiten =====
==== Differenzen zweier Tabellen ====
<code sql>
SELECT T1.Field1, T2.Field1
FROM T1 LEFT JOIN T2 ON T1.Field1 = T2.Field1
WHERE T2.Field1 IS NULL;
</code>

==== Datumsformat im Query ====
<code>#mm/dd/yyyy#</code>
<code sql>
SELECT * 
FROM myTable
WHERE myDate = #03/11/2010#</code>

==== Zeileumbruch im Query ====
Chr(13) & Chr(10)
<code sql>
UPDATE logtable
SET log = "new String" Chr(13) & Chr(10) & log;
</code>

==== Export/Import ====
Application.LoadFromText
Application.SaveAsText

==== Versteckte Befehle im Objektexplorer anzeigen ====
Objektexplorer öffnen. Rechte AMustaste auf Header: ShowHiddenMembers

===== Weitere Inhalte =====
{{topic>MS_Access}}
 ~~NOCACHE~~ 
{{pagequery>
  @vba:access: *;
  label=MS Access;
  sort=ns,title;
  display=title;
  hidestart;
  snippet=plain,all,w30;
  bullet=square;
  fontsize=100%;
  hidemsg;
  layout=table;
  group;
 }}