Updating a Paradox table

[jennyw]

Is this possible? I just tried to run this query:

UPDATE payment.date
SET payment.date = DateAdd("yyyy", 100, [Date])
WHERE payment.date between #1/1/1900# and #12/31/1903#

When I try to run this query, it tells me that it can't find
payment.mdb. However, what I'm trying to update is a linked table
called payment (which is in a file payment.db -- Paradox format). Is
it not possible to update Paradox tables from Access?

Thanks!

Jen

 

[John Spencer (MVP)]

Looks like a syntax error to me.


UPDATE Payment
SET payment.[date] = DateAdd("yyyy", 100, Payment.[Date])
WHERE payment.[date] between #1/1/1900# and #12/31/1903#

The UPDATE clause should contain the TABLES involved (and any joins etc)
The SET clause contains the item or items to be updated and their new value.

Also, I would be VERY careful with using a field named Date. It is all too easy
to get this confused with the function Date (which returns today's date).