Make Table Query

[Lpitt56]

I have a shared MS Access database that uses a "Make Table" query to create a temporary table so I can then run a cumulative total in another query. Everything works great with one exception, if the query that runs the cumulative total is left open by one user (in the process of viewing the data, printing, etc.) and another user tried to run this feature they get a Macro error (the queries are executed using a macro).



I'm guessing it's because the "Make Table" query is trying to clear and remake a table that is bound to another open query, because it clears up as soon as the other user exits the query.

My question is this.. is there a way to replace the Marco error call-back with a message stating something like "Table is currently open, try again later"? Something so the user does not think the program has a permanent glitch?

[pbaldy]

I'd go a different direction. It sounds like the application is not split, and it almost certainly should be:

http://www.granite.ab.ca/access/splitapp/index.htm

In a split application, the make table would be happening in the front end, so each user would have his own.

[Lpitt56]

Thanks! Make sense and you are exactly right! I need to convert the program to a front-end / back-end approach.

Lpp

[pbaldy]

Happy to help! I think you'll be happier in the long run.