Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Best practice question (Access03)

    If you create a temporary table with SQL and base a report off that table should you come back and delete the table using code after the report has been opened? Does that improve efficiency operation of the database? Thank you. Fay

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

    Re: Best practice question (Access03)

    You shouldn't delete the table immediately after the report is opened. You could do so when the report is closed, but you can also leave it. When you run a make-table query the previous version will be deleted. (If you run an append query, you should delete all records first).

    In either case, it is a good idea to compact the database regularly.

Posting Permissions

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