ODBC import... "Invalid Argument"!!!

T

Teo\(I\)

I need help!
On 3 PCs, with Access 2003 I've the same problem..

importing from an odbc sorce, I obtain this error: "Invalid Argument.."
If I open a DB with some linked tables and I go in the "linked tables
manager" to reconnect them I don't see nothing!! I've a blank box!

I've just upgraded all with lastest patch (jet too)... but I don't know
other solution :(
on 2 of the 3 PCs i've Access 97 too, and it work properly...

There isn't a size problem, I obtain this error importing a table with 10
records!!! (If I import this table with Access97 the db size increase to
3.65Mg only..).
And I have the problem using an old DB but using a NEW empty db too!!

some ideas????


thanks!
 
L

LuxMeansBux

I had the exact issue, and I found my problem was due to the db exceeding 2 gig, but it sounds like that's not an issue for you. One remedy for general "weirdness" like this may be to decomplile. Take a look at ACC97:How to Repair a Damaged Jet 3.5 Damaged Jet Database - 279334 see point 9... or goto http://www.granite.ab.ca/access/decompile for the whole lowdown.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top