Per srichards:
We are creating an issues tracking database using Access 2003 and would like
to export information to management, obtain their feedback and update the
database on a periodic basis. What is the best process for doing this?
Would Access 2007 make this process easier somehow?
Dunno from "best", but the first thing I'd look into is MS Excel.
In my environment, at least, just about everybody is comfortable
with working with Excel spreadsheets.
You could write code in the MS Access app to create spreadsheets
with everything protected except the cells that the managers are
allowed to update and with PKs, row counts, and column counts in
hidden columns.
The managers would over type data as needed and then flip the
sheet back to you.
You'd have VBA code to check the integrity of the sheet (make
sure nobody shifted columns around, deleted rows, and so-forth)
then pull it into a work table where you could do some basic
validity checking on the data before importing same into the
app's back end.
Depending on how simple/straightforward you were able to make the
sheets, you might even get away with just ODBC linking to them
and treating them as tables - bypassing the import into a work
table.
