Hello All,
Is it possible in access to not have the popup messages appear. I have done
the following unde MSAccess Menu:
? Tools
? Options
? Select EDIT/Find TAB
? Under Confirm UNCHECK the following:
? Record Changes
? Document Deletions
? Action queries
I created an autoexec macro to run the following:
Run Macro to delete table data (7 tables)
Run Macro to import text files into tablese (7 tables)
Run Query to append data files
When the autoexec macro runs, it runs into a problem when it is doing the
import and I get the error that states that it was unable to add or append a
record due to key violtio and nothing is imported into the table
Now, when I run the Macro Import manually, it works with problems. Any
ideas would be greatly appreciated.
Argus