Thanks in advance.
I have designed a reporting system that has 5 seperate reports that pull from the same query. So, to shorten the report run time I made that select query into an append query that updates a table. So, when the user clicks PREVIEW REPORT they are actually running a macro that deletes * in that table and runs that append query to populate the table.
Well, when I tested it on a Run-Time version of Access, it seems to let the deletion of the table data but I get an Action Failure telling me that the Append Query can not be performed.
Can Access Run-Time not append tables? Is that a limitation? If so, why did it not stop me from running the SQL to delete the data in the table? Is there a way around this?
Thank you again VERY much.
Kevin
I have designed a reporting system that has 5 seperate reports that pull from the same query. So, to shorten the report run time I made that select query into an append query that updates a table. So, when the user clicks PREVIEW REPORT they are actually running a macro that deletes * in that table and runs that append query to populate the table.
Well, when I tested it on a Run-Time version of Access, it seems to let the deletion of the table data but I get an Action Failure telling me that the Append Query can not be performed.
Can Access Run-Time not append tables? Is that a limitation? If so, why did it not stop me from running the SQL to delete the data in the table? Is there a way around this?
Thank you again VERY much.
Kevin