recent error messages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A user has used a databse for months without any issue and all of a sudden
they started getting a couple of error messages:

Error 1 occurs when the macro is run with a push button. If I step through
the code, Error 1 doesn't happen. The message for this error is something
like
"RunCommand event is being canceled". Table 1 has been growing but contains
less than 20,000 records

Error 2 message is an invalid argument message.

Any comments on why this would occur after months of use? More importantly,
any suggestions on code changes to prevent these errors from happening?

The code where the problem is as follows:

DoCmd.SetWarnings False
DoCmd.OpenTable ("Table1")
RunCommand acCmdSelectAllRecords
RunCommand acCmdDelete ** Error 1
DoCmd.Close

DoCmd.TransferText acImportDelim, "AR Import Specification", "ARMASTER", _
OutputPath & OutputFile, 0 ** Error 2


Thanks for the help..........

PS......there have been no upgrades to the machine this database is run on
(that I know of anyway). We are using Access 2003.
 
Hi

No answers but some alternatives offered. See below


JT said:
A user has used a databse for months without any issue and all of a sudden
they started getting a couple of error messages:

Error 1 occurs when the macro is run with a push button. If I step through
the code, Error 1 doesn't happen. The message for this error is something
like
"RunCommand event is being canceled". Table 1 has been growing but contains
less than 20,000 records

Error 2 message is an invalid argument message.

Any comments on why this would occur after months of use? More importantly,
any suggestions on code changes to prevent these errors from happening?

The code where the problem is as follows:

DoCmd.SetWarnings False
DoCmd.OpenTable ("Table1")
RunCommand acCmdSelectAllRecords
RunCommand acCmdDelete ** Error 1
DoCmd.Close
Click to expand...

Try the following:
DoCmd.SetWarnings False
DoCmd.RunSQL ("DELETE * FROM Table1")
---> for you to decide: DoCmd.SetWarnings True


DoCmd.TransferText acImportDelim, "AR Import Specification", "ARMASTER", _
OutputPath & OutputFile, 0 ** Error 2
Click to expand...

Possible cause: spaces in your full path and file name. Try changing to a
file/path with no spaces and see if this fixes the problem. If it does come
back and get help on how to handle spaces.
 
Back
Top