I have a scheduled task that runs at 1AM that opens the database and then I have an autoexec file in Access 2010 that automatically imports a txt file and updates all my tables and then closes the database.
This works great maybe twice and then my tables lose connection to sharepoint.
What other options should I be using?
I get updates to the data via a txt file every night at 11PM.
Thank You for your help.
This works great maybe twice and then my tables lose connection to sharepoint.
What other options should I be using?
I get updates to the data via a txt file every night at 11PM.
Thank You for your help.
