"invalid argument" error upon saving table HELP

J

JRough

I need someone who knows the answer to help me. I cannot copy or save
any tables in my tables. This is access 2003. I thought it might be
corruption so I compacted it. I got a message that said something
about "the command or action 'output to'.... can't something.
I added some fields to a table so I thought maybe changing the
structure did something so I cannot save so I took out the fields I
added. That did not help, besides it affects all the tables not just
the one table I changed. Could there be a problem with a query? How
can I narrow down the problem to something specific? This must be a
structure problem?

thanks,
 
J

JRough

Okay, I panicked. I was able to save the other tables. There is one
bigger table I cannot save but I could save the structure not the
data. So I assume my structure is okay but there is something wrong
with the data. It was from a make table query so I suppose there is
no reason I need to copy it. However I was creating queries and it
seemed like I was getting the "invalid argument" when I was trying to
create a query also. That is why I thought it was corruption. I will
try to notice when it happens. Any suggestions?
Thanks,
 
J

JRough

Actually, I cannot save other tables as well but it is possible the
data is also in those tables it is from a dbf file. I wouldn't know
which data is causing the problem.
 
F

Fred

If you don't mind me being a little blunt in an effort to be helpful, you
wrote a lot of words but gave nearly zero informaiton about what your problem
is other than it having something to do with saving tables. I would
recommend, in your post, saying exactly what action you are trying to do that
leads to the problem, and a specific discription of (the symptom of) the
problem (like what is the exact error message?)


One quick guess......make sure you are not trying to enter duplicate values
(like blanks) in any primary key fields.
 
J

JRough

There are no key fields.I am just recreating a monthly table which I
run queries on letw call it 2007_data_source. I am only copying
fields from a linked dbf (db2 I think datasource) with a make table
query it is a large file let's call the query make_data_source query.
The problem is I am trying to copy last months table before I run the
make data source query for this month. It won't let me copy/paste the
table in access. I get the "invalid argument" error. Could it be a
size limit? I noticed this access db size is 1.9 gigs. Then I also
try to copy the make table query. I also get the "invalid argument"
error. I can copy all of the other queries and tables which are
smaller.

What I want to do is add some new fields the query but at this point
I would be happy if I could run the query as it is. this is a side
question. Here is a side question, if I add the new fields I want to
the make table query, will automatically insert the fields in to my
data_source table. Now I can't even copy/paste the table structure.

Any other ideas?
thanks,
 
Top