Invalid Argument Error

From: Tcs (tsmith_at_eastpointcity.org)
Date: 08/04/04 

Date: Wed, 04 Aug 2004 10:12:56 -0400

First, I'm not sure that I'm in the correct group. If I chose incorrectly, I
apologize, and please let me know the correct group. Thanks.

I was using my Access 2000 db with no problem yesterday. I closed it down, so
my nightly backup job wound zip it and send it across the network to my home
directory.

This morning I tried to execute my query. This is one that has given me NO
problem previously. After a while I got the "Invalid Argument" error. So I
tried to modify the query.

I modified my query and I when I went to save it, I got the "Invalid Argument"
error. I tried again. Same result. So I tried to compact and repair by db.

When I tried to compact and repair my db, I got the "Invalid Argument" error.
AGAIN. (My db has grown to about 2mb.) So I tried...AGAIN. Same result.

I closed my db then opened it. I went to my query to modify it. I was able to
add two fields to the 15 that were already there. (A simple append query to
pull data off the AS/400 and make a local table.) this time? NO problem. So I
tried to add ANOTHER two fields. This time? "Invalid Argument" error. So I
tried to Compact and Repair again. "Invalid Argument" error.

I'm also getting errors when my db refreshes the ODBC links to DB2 on the
AS/400. It gets thru a bunch, then starts erroring out. This WAS working just
fine, and I haven't changed a thing.

I'm at a loss. Does anyone have any idea what's going on? And possibly how to
fix it?

Any help is appreciated. Thanks in advance,

Tom

Relevant Pages

  • Invalid query name
    ... I have created a query and when I try to test it a ... message pops up telling me it's an invalid name. ... already done a repair and rebooted the ...
    (microsoft.public.access.queries)
  • Invalid Argument on saving query
    ... My compact and repair is also giving me the invalid ... >I have was chuggin along pretty good yesterday, ... >to save a query. ...
    (microsoft.public.access.gettingstarted)
  • Re: A little help on a proc
    ... Do you care if the loginname is invalid? ... > So the best process is to rerun the query? ... >> create proc foo as ...
    (microsoft.public.sqlserver.programming)
  • Re: How do I temporarily limit values in a query field
    ... I am getting an error message: "The expression you entered has a invalid ..or! ... This is the last few lines of the 'old' sql with an attempt to limit the records to values of <500: ... works fine until I try to put limits on it value in the qryClaimDetails query. ...
    (microsoft.public.access.queries)
  • Re: Table and PHP scripts for existing data
    ... >2) once the table is created inside my database on MySQL, ... >load the data in? ... DELETE query"); ... ("Invalid DATA LOAD query"); ...
    (comp.lang.php)