Recent content by Rudolph583

Hi all, many thanks for the numerous replies! There were a lot of great suggestions and I'm working on finding the best combination of the mentioned measures to optimise the query runtime.

Hi CJ_London, many thanks for your detailled response. You are making a great point. The less than 5 seconds is indeed only the runtime to display the initial datasheet screen and it takes much longer for the number of records to be displayed. That explains why exporting and other things take so...

Hi I have run into a rather strange issue with a query and I'm wondering if any of you could think of a solution to this. I have got a SELECT query, which itself consists of several sub-queries and some of those again consist of sub-sub-queries. So overall my SELECT query has dependencies on...

Many thanks all for your detailed replies. To keep you updated: I am currently considering going for a hosted MySQL database and then try to connect to it via ODBC. I would then have a simple PHP web form (hosted with the same provider as the MySQL database) for data entry and data display while...

Hi all, I am working on a new project and would appreciate your advice on how to best implement this. Basically, I am looking to build an app which I can use to manage my perosnal to-do's (tasks). I have already implemented everything in a locally stored Access database. Very simple stuff...