Use of Microsoft Access as an analysis, verification & automation tool
TheBaneOfMyLife last edited by TheBaneOfMyLife
The primary data sits in SQL Server. I’d like to use MS Access to extract the data from SQL, add new fields per record (not changing the existing records in any way), assign values and classifications to the new fields and then produce summary outputs based on the new fields. The process is self contained and the user does not edit the data either in SQL or Access - they just choose the run date and the comparative period.
What issues am I likely to face in SOX terms?