Digital Workshop

I am creating an application for scanning (using a barcode scanner) part numbers and serial numbers into an Excel spreadsheet. I have set up the database links, but when I run the application, it says I do not have permission to write to the file. I can't find out what's going wrong.
I want to check that Opus can actually do this???

Hi,

Thank you for your enquiry.

Is the .xls file set to Read Only? Try right-clicking on the original .xls file, select Properties and click on the General. Now ensure that the Read Only option is disabled and click OK.

Now try previewing your publication and see if the Add Record action now operates as expected.

I hope this helps. Please do not hesitate to contact me if you have any further queries.

Kind regards,

Thanks Robin, I found a tick box in the DSN set up which had been set to prevent update of the file, so it works OK now.

I use INSERT NEW RECORD to add data to an Excel file, however Each time I run the application, it adds the new record to the bottom of the existing data. Is there some way of resetting the pionter which must be stored somewhere so it always adds the data starting at row 2 of the spreadsheet.. I have tried clearing the spreadsheet of all data, but it still inserts where the last INSERT finished.

Thanks

Hi,

Thank you for your reply.

This is a known limitation of the Excel ODBC driver, and is highlighted in the following article:

http://support.microsoft.com/default.as ... bContent=1

As this article states, 'the [Excel ODBC] driver will not support DELETE, UPDATE, or ALTER TABLE statements. While it is possible to update values, DELETE statements will not remove a row from a table based on an Excel spreadsheet. These operations are not supported. Basically, you can only append (insert) to a table.'

If you wish to have direct control over the updating and deleting of rows from your data source, I would recommend using an Access database.

Kind regards,

Thanks Robin---I will just have to live with it just now. At least I now know it can't be done.