hans_v

Try this:

Dim sqlUnion As String = String.Format("SELECT Kreditor_ID as Kredi_ID,Kreditor as Kredi FROM tblVertrag IN '{0}' INNER JOIN tblVertragGattung IN '{0}' ON tblVertrag.ID=tblVertragGattung.VertragID WHERE GattungID=? ORDER BY Kreditor_ID UNION SELECT Kredi_ID,Kredi FROM Projek WHERE Lager_ID=?", Server.MapPath("~/App_Data/Visieren.mdb"))

This gives me Error even when running on my computer - Syntax Error in From  Clause