Re: Error when I run Append queries

Is it possible that one or more of the fields being selected for insertion
are Null, and the corresponding field(s) in the receiving table can't accept
Nulls?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Don" <Don@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:70651815-E0CF-4DEF-978A-D665C159C560@xxxxxxxxxxxxxxxx
>I have a networked application that links to another program's data files
>and
> appends updated information into my networked Access application. This
> networked application is split. The problem I am having is suddenly when
> running Append Queries I now get an error "Invalid Argument". These Append
> queries have run for the last 6 months without a problem and I do not know
> what has changed, (possibly a corrupted Dll file)? This error seems to be
> on
> all of the computers on the network including the server (Frontend in a
> different directory to run tests on updates). The help indicates that "You
> tried to perform an operation that involves a routine in a DLL, and one of
> the arguments to the routine is invalid. Check your entry to make sure you
> have specified the correct arguments, and then try the operation again.
> This error also occurs when you attempt to use mutually exclusive
> constants
> in an argument to a method, such as specifying both dbConsistent and
> dbInconsistent in the options argument to the OpenRecordset method."
>
> Code ran for update query to get this error:
>
> INSERT INTO PATIENTS ( CDC_NBR, LASTMOVE, UNIT, LNAME, ALLERGY )
> SELECT PATIENT.CDC_NBR, PATIENT.LASTMOVE, PATIENT.UNIT, PATIENT.LNAME,
> PATIENT.ALLERGY
> FROM PATIENT
> WHERE (((PATIENT.UNIT)<>"Gone"));
>
> All table and field names are correct.
> As well as this code:
>
> INSERT INTO RX1 ( CDC_NBR, RX_NO, [DATE], STOP, DRUG, IDRUG, QTY, SIG1,
> SIG2, DR, START )
> SELECT Rx.CDC_NBR, Rx.RX_NO, Rx.DATE, Rx.STOP, Rx.DRUG, Rx.IDRUG, Rx.QTY,
> Rx.SIG1, Rx.SIG2, Rx.DR, Rx.START
> FROM Rx;
>
> I checked and found nothing that I could identify to be a problem. Note
> that
> all Delete queries and Update queries continue to work without errors.
>
>
> Thank you,
>
> Dennis


.

Relevant Pages

  • Error when I run Append queries
    ... I have a networked application that links to another program's data files and ... running Append Queries I now get an error "Invalid Argument". ... all of the computers on the network including the server (Frontend in a ...
    (microsoft.public.access.formscoding)
  • Re: Local tables or linked local database?
    ... How good of a job does Access do mitigating the amount of ... You have used passthrough queries. ... network load - with a network full of people sending emails, printing, ... My posts come from my experience. ...
    (comp.databases.ms-access)
  • Re: Speed problem
    ... only at one client, their several invoices, etc. ... However, on the network, some things are happening at ... they do bring together a buncha tables via queries). ... mostly on the terminals). ...
    (comp.databases.ms-access)
  • Re: Slow Form Loading Over Network
    ... >So when you have a large table that's stored on a network drive and filter ... >To optimize the queries in the views, you can use the SYSfunction. ... >> The form loads instantly on a standalone machine, ... >> optimized using the tag on DELETED. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Query Trap!
    ... How are you retrieving the primary key value from the first append query ... it runs two append queries. ... Then if I choose another control, ...
    (microsoft.public.access.queries)