See attached message (file called access_repair.jpg).
We have a process wherein a Microsoft Access database is linked to a Quick Books database. This process runs on a Windows XP scheduled task every night. It consists of bat files, ftp to a web server and running macros & queries in the access DB.
I am aware of the fact that XP has "expired" & is no longer supported by Microsoft.
The last two nights, the process has failed with the attached message.
See attached file called Linked_to_Lss. This shows the tables in the database; note some are externally linked; those connect to Quick Books tables.
Is it safe to do the suggested Repair? Will that NOT effect the Quick Books tables?
Why would this all of a sudden be a problem? It's been running for years. Slight changes were made a few weeks back but it has run properly for about two weeks.
I can provide the main macro & all of the executed queries, if need be.