I need to be able to schedule an overnight process to copy data from an Access database to a SQL Server database.
This is currently done manually by a user clicking a button that runs append queries and linked tables in the Access DB. I need to automate the process. The windows scheduler will not allow an Access DB to be run 'unattended'. I have tried all combinations of using .bat, .vbs files, auto-exec macros, and different users (SYSTEM etc), and nothing will execute the Access DB. It needs a window to open in.
Any suggestions please? Would a VBA application work?