SELECT on Query

M

marcobastel

Hi,
I took over the support of a "strange" access databse. It worked fin
until we changed the location on the server. It contains som
statements like:
INSERT INTO ERGEBNIS_SELEKTION_TEMP ( SELEKTION, PERSON, FIRMA )
SELECT A.SELEKTION, B.KENNUMMER , B.FIRMA FROM A_ANZ_ERGFIRMA_G A
PERSONENDATEN B
WHERE A.FIRMA = B.FIRMA AND ANZF = 1

a_anz_ergfirma_g and Personendaten are defined as queries.

In the past it worked fine but since the location switch I always get
prompt to enter the parameter values for each field in the querie
a_anz_ergfirma_g and Personendaten.
Does anybody have a glue why it's not longer working ?
Thanks
 
J

JohnFol

my glue is the a_anz_ergfirma_g and Personendaten queries are trying to
reference something that no longer exists. For example a control on a form.

What happens if you open each of these up?
 
Top