Search results

I think you're right. I just found a Paradox convertor and it shows the contents properly. This one is limited to 50 records in the trial version, but at least I know what I have now. Many thanks. How did you know?

This is a bit off topic, or off strictly Access, but people here have experience with all sorts of stuff - maybe someone will have an idea. I've been handed what is supposedly a database, of completely unknown origin. It has a .DB extension, which causes searches on the topic to flood me with...

Yes, I acknowledged that the hash might be a good idea, and thanked you for the tip. I have also several times explained to you why indexing the table as it is now is not possible, and even if it were possible, would likely still not solve the problem of the delete query doing repeated scans...

You didn't, and I'm not. You can't with the graphic - it doesn't even offer a memo field. You have to do it with DDL. And if it only indexes part of the field, it would be useless for my purpose. And even if it did, I still can't have an index that would cover the entire table, because there is...

And what good would that do? I do have a few such indexes, for lookups, and they work nicely. But for this task, I am looking for duplicate records across the ENTIRE set of fields, except the unique PK. An index speeds up finding a record by a key value. More indexes do not make this faster -...

Again, I have over 50 fields - too many for an index, and memo fields cannot be indexed at all. The problem is not the scan, it is that the scan is being pointlessly repeated.

Just saying 'you are wrong' provides zero benefit to anyone, especially as I am NOT wrong. I have described a problem and the limitations I am encountering when trying to perform a task. I can't use an index because of those limitations - the number of fields that an index can contain, and the...

I have explained what I am doing in previous answers, and I have explained why an index would not help.

I explained that further on in that answer. Yes, it is slow, but not intolerably so, as long as the scan is done ONCE. It takes less than half a minute, which is entirely acceptable for this function. My problem, as I have written repeatedly, is that the scan is being done over and over...

A bit late, but for the archives... Just press ctrl/Enter instead of Enter, and you can enter multiple lines in the ControlTip box.

Yes, memo fields cannot be indexed, but that has no bearing on this problem. I am not looking things up, so an index would provide no benefit. I am comparing the entire record, every field, looking for dups of the entire record. That means reading in the entire record, every record, from the...

I did, but it does the delete a different way. My issue seems to be the long-running subquery, which is what I need to detect duplicates. I have to check every field (except the unique ID) to determine if I have a duplicate, including two memo fields. The Having Count(1) > 1 clause gives me the...

No, I will not be adding an index to prevent future duplicates. The index would have to cover every single field in the table, except for the unique AutoID. That would be a monstrously unwieldy index - two, actually, since I have 52 fields in the table. The table even includes two memo fields...

I read that, thank you, but I don't see anything there that helps me.

Is there some difference between IN and NOT IN? I tried it both ways, IN ... Having Count(1) > 1 and NOT IN ... Having Count(1) = 1, and both ways hung with zero visible progress. I had to kill the process to make it stop. I don't know how I would use Exists and Null in this scenario. I want to...

I’m trying assemble a query to delete some duplicate rows in a customer’s database. I want to leave ONE instance from every set of duplicates. DELETE DISTINCTROW * From Zaznamy Where ZaznamAutoID In (Select First(ZaznamAutoID) from Zaznamy Group By {field list} Having Count(1) > 1) This should...

Didn't think of that. Good idea.

I wrote up an article about a systematic way I developed of passing information back from a form called in dialog mode to the form that called it. I tried to publish it here, but this site has a limit for the number of characters allowed in a post, and my article exceeded it, by quite a bit. I...

Hm, that looks interesting. Far more involved than what I am trying to do, but it looks useful. It will take me some study, though. Thank you.

"But I would like to know which key was pressed. That is available in the KeyDown and KeyUp event procedures, but I have not found a way to pass it via a function." The event procedure has the parameter KeyCode, but that same parameter is not available to be passed via a function, or at least...