Digital Workshop

Hi

Have developed a program that does a number of access database queries, occasionally in rapid succession. Occasionally these queries appear to be failing, and this might be causing the program to freeze. Just wondered if there are any issues to be aware of regarding using an access database, and doing frequent queries on different tables within access. For example, if I ever have failed to close a query, will that cause future queries to fail?

The problem we are experiencing (which may or may not be related to an access database) is that a number of (more modern) PCs seem to be hanging in an Opus publication. Clients have reported that older PCs don't appear to be affected. Haven't managed to establish any specific PC specification that causes the problem, but it occurs in XP so it's not related solely to Vista or Windows 7.

Would be delighted to hear anyone's feedback.

Thanks

You say some of the queries are done in rapid sucession? have you tried adding some delay to ensure the first query is complete before another starts? . You could error trap for a valid return, so the next query can only be started when the first is complete.

There are many possible causes of the program freezing, and I am trying to narrow down the number of possibilities. It would take a number of days simply to add a time delay or check to the system. My question is whether there are any issues to be aware of regarding using an access database, and doing frequent queries on different tables within access. For example, if I ever have failed to close a query, will that cause future queries to fail?

I am having this issue as well, I need a way to check my Access Queries are definitely closing before another one opens. Any advice on the best way to do this would be greatly appreciated!

Hi - Sandyn mentioned that I could error trap for a valid return, so the next query can only be started when the first is complete. How can I do this? I've no idea how to 'error trap' and don't know any scripting?

Trapping errors for DBs using script:



In the first instance, the value of k will be true if the value was inserted into the DB and false if it failed. In the second instance, the value of j will be an object holding the dataset if successful and false if failed.

Mack

Thanks Mack, would we be able to insert this script onto a master page (which is used for the pages which perform queries) or would it have to be on each page where the queries are run? I'm a complete script newbie so forgive me if this is a stupid question.

Sorry Jay, that's like throwing darts with the lights off!

Mack