Re: Access won't commit (to SQL Server linked table)

Cheers.

Unfortunately the query was running from VBA originally when the
problem was discovered. I started it running "manually" to try and
simplify things. The weird thing is, it works sometimes but I can't
work out what why.

Anybody else got any ideas? Maybe I should try a SQL Server group.

Tim

.

Relevant Pages

  • Re: Access wont commit (to SQL Server linked table)
    ... Biguana wrote: ... Unfortunately the query was running from VBA originally when the ... simplify things. ...
    (comp.databases.ms-access)
  • Loop through fields and update nulls to zeros
    ... How would you loop through fields and update null values to zero's in vba? ... If it was only one field, I would run a query or write an SQL statement. ... Prev by Date: ...
    (microsoft.public.access.modulesdaovba)
  • Re: Tricky Delete Problem
    ... I can't think of a way to do this with a query. ... It would require some VBA ... in a database. ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Type Conversion Failure in Update Query
    ... I put in the code and it still seems to give me "type conversion failure." ... I restricted the query to one field at a time to simplify things: ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Cant figure this out !
    ... Ok, will try to simplify. ... opens with a status of either active or archived records. ... The below code is in the query for the forms employees list and so shows ... Prev by Date: ...
    (microsoft.public.access.forms)