Replies

That’s a good guess, but it didn’t help. I’ve shortened the name of the query and removed all underscores (it’s now called CompareOrders) but it is still invisible.

Ian

So do I assume that it’s not just me that has to use nested queries when selecting records for deletion (when the decision on which records to delete is based on information in another table)? Is there an alternative?

I didn’t realise that nested queries slowed things down so much. As it happens I went down the temp table route and that worked OK.

The reason that I used a nested query was that I couldn’t get the query to run when I included the second query in the FROM clause of the ‘main’ query. The query would list the records to be deleted, when run from the datasheet view button on the top left of the screen, but refused to work when run from the red exclamation mark, or from code. I often find this with delete queries, and usually get round it by using a nested query to select the records to be deleted. I guess I’ve only deleted from mdb based tables using this approach before. But what I would like to know is why it happens. What is it about delete queries that makes them insist on having their WHERE clauses based on a nested query (I think it is only required when the selection is based on the contents of a table that is not the one that the records are being deleted from)? Other action queries don’t seem to be so fussy.

Ian

Hi Wendell,
The dbi tech controls look good. I’m particularly drawn to the multi-column day view component that comes with PIM Professional 3.0. However, the prices are steep. Do you know if the prices that they quote for user licences refer to the developers or to the final clients? Would I have to include the price of their 5 or 10 user license every time I created something with these components, or do I just have to buy the single user license once, for my development PC?
Ian

Thanks Mark. I checked out the DTSearch website but, unless I misunderstood, their Web site version costs about $1000, which is out of the range of this project.

Ian

Edited by HansV to make URL clickable – see Help 19

That was my fallback position. I think there may be a way of doing it using API calls though. I found an article called ‘Ping with VB the easiest way using IPHLP.API’ on http://www.freevbcode.com/ShowCode.asp?ID=4945%5B/url%5D. I copied the code into an Access module, and it runs, but it gives false negatives, claiming to have failed on IP addresses that I know I can ping from the cmd window. Unfortunately I can’t work out why because the code is based around two API calls, and even if I could understand what was going on inside them, the de###### won’t take me there. I wondered if anybody had seen any other API calling code that might do a similar job?

Ian

Edited by HansV to make URL clickable – see Help 19

That was my fallback position. I think there may be a way of doing it using API calls though. I found an article called ‘Ping with VB the easiest way using IPHLP.API’ on http://www.freevbcode.com/ShowCode.asp?ID=4945%5B/url%5D. I copied the code into an Access module, and it runs, but it gives false negatives, claiming to have failed on IP addresses that I know I can ping from the cmd window. Unfortunately I can’t work out why because the code is based around two API calls, and even if I could understand what was going on inside them, the de###### won’t take me there. I wondered if anybody had seen any other API calling code that might do a similar job?

Ian

A corrected version of the installation email has been sent, the link in it worked and the database has been recovered, as far as I can tell. I’m not sure I would recommend their web site/designers to anybody but the product itself appears to work (very quickly and simply) and they may well have had someone working on Sunday, it’s hard to tell. All in all, I’m happy again, although I wasted a lot of my weekend unnecessarily.

A corrected version of the installation email has been sent, the link in it worked and the database has been recovered, as far as I can tell. I’m not sure I would recommend their web site/designers to anybody but the product itself appears to work (very quickly and simply) and they may well have had someone working on Sunday, it’s hard to tell. All in all, I’m happy again, although I wasted a lot of my weekend unnecessarily.

Very disappointing so far. I paid the money and was sent an email with a link to follow for immediate dowload. This link , the email informs me, is only avaiable to me for seven days.
On following the link I get a page with this message:

We’re Sorry!
The page that you have requested can not be found or has been moved.
We suggest that you use the navigation links found on this page to ensure that you find what you are looking for.

This page is on another company’s site and does not contain any information about AccessRecovery at all.
I have emailed the support addresses, but I am now despondent.
I have spent a lot of money
I have no software
The web site(s) involved are no help at all
There’s no advice in the demo product (the help section on upgrading to the full version is just a glorified link to the buying section of the web site – been there!)
The support personnel will probably not even be able to help until the US wakes up, which is half a day after my clients wake up in the UK
The promised 5% discount for respnding in 24 hrs was not deducted
Oh, did I mention that my clients still don’t have any data.

Very poor service and yet another selling web site that offers next to no help when things go wrong.
Every time I read their seven day deadline in their email I feel a bit more warmly disposed to the NRA.

Ian

Very disappointing so far. I paid the money and was sent an email with a link to follow for immediate dowload. This link , the email informs me, is only avaiable to me for seven days.
On following the link I get a page with this message:

We’re Sorry!
The page that you have requested can not be found or has been moved.
We suggest that you use the navigation links found on this page to ensure that you find what you are looking for.

This page is on another company’s site and does not contain any information about AccessRecovery at all.
I have emailed the support addresses, but I am now despondent.
I have spent a lot of money
I have no software
The web site(s) involved are no help at all
There’s no advice in the demo product (the help section on upgrading to the full version is just a glorified link to the buying section of the web site – been there!)
The support personnel will probably not even be able to help until the US wakes up, which is half a day after my clients wake up in the UK
The promised 5% discount for respnding in 24 hrs was not deducted
Oh, did I mention that my clients still don’t have any data.

Very poor service and yet another selling web site that offers next to no help when things go wrong.
Every time I read their seven day deadline in their email I feel a bit more warmly disposed to the NRA.

Ian

Yes, the first thing I do with a corrupt database is go through a sort of check list:

1) Compact and Repair
2) JetComp (in this instance the one for 2002 that you get from KB article 295334)
3) Try importing the objects into another database
4) Talk to the users about backup
5) Dispair, and dust off my SQL Server training notes

Most of the time Compact and Repair works. When it doesn’t the chances of the others working are, in my experience, slim. Occasionally they do, and that has been a lifesaver, but mostly they don’t.
I now have a desperate user and the demos of two products, both of which seem to have succeeded where the standard and free alternatives have not. I’m going to bite the bullet and buy the full version of AccessRecovery. I live in the UK and with the US dollar being so low at the moment it only costs me a few more quid anyway. I’ll post my results.

The dollar really is low at the moment. I wonder if there’s any other software I should be looking into?

Ian

Yes, the first thing I do with a corrupt database is go through a sort of check list:

1) Compact and Repair
2) JetComp (in this instance the one for 2002 that you get from KB article 295334)
3) Try importing the objects into another database
4) Talk to the users about backup
5) Dispair, and dust off my SQL Server training notes

Most of the time Compact and Repair works. When it doesn’t the chances of the others working are, in my experience, slim. Occasionally they do, and that has been a lifesaver, but mostly they don’t.
I now have a desperate user and the demos of two products, both of which seem to have succeeded where the standard and free alternatives have not. I’m going to bite the bullet and buy the full version of AccessRecovery. I live in the UK and with the US dollar being so low at the moment it only costs me a few more quid anyway. I’ll post my results.

The dollar really is low at the moment. I wonder if there’s any other software I should be looking into?

Ian

Finally worked out how to download the AccessRecovery demo. It also seems to work. It allows you to save but only leaves real data in some of the records. There was there to confirm that the primary keys and autonumbers are intact.. So far it looks the better bet.

Ian

Finally worked out how to download the AccessRecovery demo. It also seems to work. It allows you to save but only leaves real data in some of the records. There was there to confirm that the primary keys and autonumbers are intact.. So far it looks the better bet.

Ian