Hello folks,
Probably a simple thing, but I'm not accustomed to using Access or ODBC.
Managment want an app developed in MS Access which should share info from an FPW2.6 app.
Linking via ODBC from MS Access is trivial (using the Visual Foxpro Database -- Free table) ODBC driver.
However, I'd like to be able to make this table read-only, so that changes can only be made via the FPW application, which does audit trailing etc. Also I'm very dubious about the way the FPW26 and ODBC record locking may or may not work together during editing.
Is there an easy way of doing this in MS Access? Or would this be best done at OS level by user-permissions? Any advice welcome...
John
Dr. JW Faithfull
Curator in Geology
Hunterian Museum
University of Glasgow
Glasgow G12 8QQ
Scotland