If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
'Invalid argument'
I am using Access 2002 SP3 and I have a large table with
2.6 million records and some other tables totaling approx 125,000 records. On the large table, it was imported as a text file and now if I try to change the length of a text field or an index it will not perform the change and gives error 'Invalid argument'. I installed SP3 according to a KB article but still getting same problem. Anyone else encounter this and get around it? I already compacted and repaired which didn't help. Any ideas ? |
#2
|
|||
|
|||
'Invalid argument'
The only thing I've ever seen about that suggests that it may be related to
the size of your file. You can read something on it he http://support.microsoft.com/default...b;en-us;835416 What is the size of your .mdb file? You may need to split the database to see if that helps. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "susanc" wrote in message ... I am using Access 2002 SP3 and I have a large table with 2.6 million records and some other tables totaling approx 125,000 records. On the large table, it was imported as a text file and now if I try to change the length of a text field or an index it will not perform the change and gives error 'Invalid argument'. I installed SP3 according to a KB article but still getting same problem. Anyone else encounter this and get around it? I already compacted and repaired which didn't help. Any ideas ? |
#3
|
|||
|
|||
'Invalid argument'
Thanks Lynn, I'll look at that one and see if it helps.
However, I suspect you are correct in that the db is just too big. Thanks again! -----Original Message----- The only thing I've ever seen about that suggests that it may be related to the size of your file. You can read something on it he http://support.microsoft.com/default.aspx?scid=kb;en- us;835416 What is the size of your .mdb file? You may need to split the database to see if that helps. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm "susanc" wrote in message ... I am using Access 2002 SP3 and I have a large table with 2.6 million records and some other tables totaling approx 125,000 records. On the large table, it was imported as a text file and now if I try to change the length of a text field or an index it will not perform the change and gives error 'Invalid argument'. I installed SP3 according to a KB article but still getting same problem. Anyone else encounter this and get around it? I already compacted and repaired which didn't help. Any ideas ? . |
Thread Tools | |
Display Modes | |
|
|