Please help!

[PainGypsy]

I built a form(AddNewItem) on a query(AddNewItem) that contains a coupl
Access tables and an entire linked FoxPro table. The form is to ad
records to the foxpro(inventry) table bassed on information in th
access tables. I have a control that builds a query string in VBA an
then uses the docmd.runsql using the query string.

Here is the thing... If I replace the FoxPro table with an access tabl
the entire things works swimmingly!! If I link and use the FoxPro tabl
it gives me a syntax error in update query, then if I run the sam
control again it says it can't update the record because of a Ke
violation, although it creates the record and fills a couple fields
THEN! if you run it a 3rd time it works perfectly... It's the exac
same query string each time.

The form works perfectly with an access table. Does EXACTLY what I nee
to do... however, it flips as described when I replace the table with
linked foxpro table :-\

I'm sure there are some questions I could answer that would hel
resolve this, so Please ask away!

Any and all help is GREATLY appreciated. I have been trying to resolv
this for days and posting in several forums and e-mailing lots o
people. Can't seem to get help at all... I need to get this running b
monday we have over 2k Items to put into the DB and this is going to b
the tool to do it! (I hope) I also have the file available if anyone i
interested

 

[Rod Scoullar]

Very odd.

Some dumb suggestions not solutions but possible work arounds.

1) If the query always works on the third try you could use error handling
to force it to run three times for each record.

2) Use the Access table to temporarily store the data and when that is
filled copy across to the FoxPro table.

Rod Scoullar