programmerchick
Programmer
My database has an access 97 front end and an Oracle 8 backend.
I'm trying to print a label-like report with 3 columns and 17 rows per page. I have been able to get the specific data I need, but when I run out of data, the formatting stops. I have tried dumping the data into a table first and setting the recordsource of the report to the new table. Because Oracle has different record security than access (when you edit/update a record in oracle the block is placed only on that current record and when you edit/update a record in access the block is placed on the entire recordset/query/recordsource.) I am getting a run time error stating another user is trying to change the same data at the same time.
Any suggestions on how to get around this? I have considered creating a multidimensional array, but that just seems like a lot of work.
Thanks!
Sharon Mihal
smihal@mpea.com
I'm trying to print a label-like report with 3 columns and 17 rows per page. I have been able to get the specific data I need, but when I run out of data, the formatting stops. I have tried dumping the data into a table first and setting the recordsource of the report to the new table. Because Oracle has different record security than access (when you edit/update a record in oracle the block is placed only on that current record and when you edit/update a record in access the block is placed on the entire recordset/query/recordsource.) I am getting a run time error stating another user is trying to change the same data at the same time.
Any suggestions on how to get around this? I have considered creating a multidimensional array, but that just seems like a lot of work.
Thanks!
Sharon Mihal
smihal@mpea.com
