Search results

At my job each computer has read-only access to the Cdrive of the other computers. So here's the problem. I need to store an Access .MDB file on one of the computers (for read-only access). About ten users will connect to it (probably no more than two or three at a time). With DAO I couldn't...

Ah, I'm beginning to grasp your post about DoEvents. Nice tip. However,I'm not using the Access engine. I'm just driving a Jet database using C#.Net. I don't have permission to install the Access runtime on the user machines (even though it's free).

I heard somewhere that anytime the filesize grows beyond 2 Gigs, even if momentarily, there is a danger of corruption. So that's why I want to compact every 100,000 new records.

Someone advised me to use the BackgroundWorker to spin the thread. For some reason DAO works fine when the BackgroundWorker creates the thread. Solved.

Well, that's not working either. The whole form blocks - the cancel button never becomes visible or accessible.

Come to think of it, I wonder if there is a way to create the cancel button on the thread. Then I could move all the code back to the main thread. I'll have to try that next.

I have a bit of Access experience but am new to threading. I'm using C#.Net to load millions of records into an Access DB. I spun off a thread as to give the user the option to cancel the operation and resume later. Actually I'm using OLEDB to populate the DB. However, I'm not aware of a way...

I don't think the problem was with Access. The logic is setup to parse small textfiles (50KB in size) and load the data in Access. What I didn't know is that, in one case, the IT dept zipped hundreds of them into one large zipFile (120 MB). So when my logic tries to load the file, it probably...

I didn't realize that. Ok, fair enough - but it's also illegal to drive over the speeding limit, jaywalk, park your car in a restricted zone, etc. Look, I'm not trying to be morally perfect here. I'm just trying to uphold some kind of minimal moral code. My present code is averse to stealing...

Yes, I rethought the matter and purchased a "full retail box" edition online (upgrade version).

Yes, it must be something like that - the second batch of data is going way past the half million mark, so the first batch must have had a bad record. I'll probaby figure this out eventually.

I'm expecting it to be a bad record causing the problem - maybe i'm inserting a null somewhere, or a value too large for the field. At the moment I've restarted the code (on a different batch of data) to see how many records get populated before it crashes again - I'm wondering if it will crash...

Now I just have to figure out why it has been crashing after a half-million records.

Oh god, i'm a complete idiot. Those columns are set to "Number" not autonumber - can't read.

I went into SQL view and typed out an INSERT INTO command (inserted one record) and here again, the record inserted, but the Autonumber column didn't populate. (I did not use parameters in this manual insert). So even if the @-params are causing problems, they are probably not the cause of this...

I have a sub which adds parameters automatically to a cmd object (which has proven very successful in other projects). So I create the cmd object like this: OledbCommand cmdINSERT = (OleDbCommand)oQuery.Parameterize("INSERT INTO Accounts (FileID, Account) VALUES (@FileID, @Account)")...

Anyone know why the Autonumber column isn't populating?

Right, but it only grew to 190 MB and, after the crash, it compressed (i.e compacted) down to 45 MB.

I'm using C#.Net code to populate an .MDB file (with data pulled from textfiles). This is my first experience with a large table. After populating half a million records my C#.Net program called "SearchText" closes with a message, "SearchText has encountered a problem and has to close. We are...

I'm pretty optimistic that my reading is correct. Originally I thought it was home-and-student software but, as I noted above, it's home-software. Microsoft's Eula's apparently distinguish between "home-software" and "academic software". Home-software can be used, apparently, for commercial...