Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Make Table vs Append query (Access2000-03)

    I have tons of Reports in Access 2003 based on queries etc.

    When I ran first Report it runs well but second one will give an error 'Table in use by another process'.

    I found out if I am switching from Make Table Query to Append query this problem is gone.

    My problem is that I need to re-write so much now and add Delete and Append queries to all modules. It is a huge pain!

    Any advice on how to break Made Table connection after executed?

    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Make Table vs Append query (Access2000-03)

    You have asked the same question twice before - in the threads starting at <post:=677,752>post 677,752</post:> and <post:=678,850>post 678,850</post:>. We didn't find a solution then, and I don't think we will find one now.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2005
    Posts
    614
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Make Table vs Append query (Access2000-03)

    Yep, I said I found solution by switching MAke Table into Append. So Append IS a solution.
    I was just hoping if I am re-wording it - maybe it will come up under a diferent light and under that light some other ways will become more visible than before.
    Thanks

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Make Table vs Append query (Access2000-03)

    The problem that you experience (a table remaining in use after it has been created by a make-table query) is not standard behavior. I don't think it is possible to find its cause and to solve it from a distance - I expect that it requires someone to look at your system directly.
    Of course, I could be wrong - perhaps someone will come up with a brilliant suggestion. <img src=/S/crossfingers.gif border=0 alt=crossfingers width=17 height=16>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •