Invalid Argument (error 30001)

[pon]

I am receiving a error " Invalid Argument" only when I run a Make Table
Query . But the select query is working fine.
I also get the error when I import the table.
Please Help!
Thanks
Pon

 

[Jerry Whittle]

Show us the SQL. Open the query in design view. Next go to View, SQL View
and copy and past it here.

 

[pon]

SELECT DISTINCT TST.TST_RUCL_CODE, TST.TST_DOC_CODE, TST.TST_ACTIVITY_DATE,
TST.TST_TRANS_DATE, TST.TST_TRANS_AMT, TST.TST_TRANS_DESC, TST.TST_DR_CR_IND
INTO MTB_FGBTRNH
FROM TST;

Thanks
PON

 

[Jerry Whittle]

Simple enough SQL statement. Even the DISTINCT shouldn't matter.

Wait a minute! I just reread what you said. Is TST a table or something like
a linked Excel spreadsheet? Access often guesses at the datatype based on the
first few rows of data in the spreadsheet. If TST_ACTIVITY_DATE has data that
looks like a date but later has something like "No Activities" later on, that
can cause problems.

If so, two suggestions:

1. Look at the data in the spreadsheet carefully for things that would mess
up Access. Make the second row of data look correct by creating a bogus
record.

2. Pre-build the MTB_FGBTRNH and make all the field Text(255). See if it
imports then. If so try to change the field data types to things like Date
and see if it errors and where.

 

[pon]

TST is a linked oracle table, I get the same error even when I import the
table.
Its a very big table. The size of the access database is nearly 1.9GB, Can
that cause any issues.
Pon

 

[Jerry Whittle]

That's too big. Access has an upper limit of 2 GB for a .mdb or .accdb file.
I'm betting that Access is running out of steam. You may have to do the work
within Oracle using pass-through queries.

 

[pon]

Even when I delete some of the imported table, the size still shows as 1.9GB.
could you please help!
pon

 

[Jerry Whittle]

Have you tried to Compact and Repair that database? That should reduce its
size.

 

[pon]

Yes, it creates another database DB1 rather than overwriting the same database.
PON

 

[Jerry Whittle]

There's various reason for that to happen. You might not have read, write,
create, and delete for the folder holding the database file. Actually you
must have read and create as it is making the backup DB1.mdb file.

It also could be that the file is so large that it can't be compacted. One
reason for that is that there isn't 2 GB of free space left on that drive.
Not likely though.

Here's something to try. Create a new database file. Then import everything
from the original database file into the new database. This might make it
smaller.