Problem with update table.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Did anyone know is it possible to update two table at the same time with one
update-query? If not is there any other solution or hints?

Best regards,

Pat
 
Hi,


It is possible, with Jet, but not suggested, to update in more than one
table. With Access 2003 adp form, you can also update multiple table at a
time, form MS SQL Server. That may be useful when your form is based on a
view involving multiple table and the end user is not aware of the internal
design... otherwise, the end user may be careful in which fields can be
updated and which cannot.



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top