Question Preventing overwrite of data by external 'save as'

Chrafangau

Doing it wrong
Local time
Tomorrow, 02:00
Joined
Sep 9, 2013
Messages
30
I have just finished blundering my way through creating a database for processing survey data into a report format. We receive these reports as paper copies, which are then scanned in using Remark Office OMR. This results in a table of data, which is intended to be appended to the existing table in the database using Save As --> Access 2007, selecting the database and target table, clicking save as, and then selecting 'Append' from the subsequent popup.

What I want to know is: Is it possible to disable/otherwise prevent the 'Overwrite' option in this window from being selected? Can I make the table or database in such a way that data can only be added, not edited or deleted?

Thanks in advance, and if you need screenshots just ask.
 
Use an append query to append your scanned results to your existing survey data.
 
An append query will work fine once the data is in Access, but what do you propose for exporting the data from ROO to the database safely? If I were able to ensure that each time a new survey were scanned the user opened the database, ran the append query, cleared the source table and everything, this would be fine, but I expect that multiple surveys will be processed between each use of the database. If preventing an external overwrite is impossible, then using a dummy table as the export target and then appending it may be a good workaround, but it's not my first choice.
 
For lack of a better option, I have decided to use a dummy table as the target of my data export, then append this data into the main data table in order to reduce the quantity of data that will be lost in the event of an accidental over-write.
While this is workable, if anyone does happen to know a way of preventing table overwrites I would really appreciate it.
 

Users who are viewing this thread

Back
Top Bottom