Problem Printing From Access 97 Run-Time Front End

J

Jeffrey_Chcgo

I am having a problem with a split run-time Access 97 database. Using VBA I
attempt to print a report. The record source for the report is a table
residing in each of the End User’s front-end. At the beginning of the print
process I use a query to delete all records from this table. Upon executing
this query I get the run-time error:

Run-time error ‘3086’. Couldn’t delete from specified tables.

I don’t encounter this error when trying to execute this print job using a
non run-time front end. I also do not encounter this error when a Power User
logged onto the computer that houses the run-time front-end tries to execute
this print job. I only encounter this error when a regular User logged onto
the computer that houses the run-time front end tries to execute this print
job. Can anyone help me with this problem?

Thanks.
 
Top