Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Error on transfer text

Discussion in 'Information Technology' started by David Widener, Jul 28, 2006.

  1. David Widener

    David Widener
    Expand Collapse
    Guest

    Hi when the code below runs I get the message

    'The Microsoft Jet engine cannot open the file 'SumOfcurStateEeSIT' it is
    already opened exclusively by another user, or you need permission to view
    its data'.

    FN = Format((Now), "yyyymmdd") & "-tblNewQtrTaxExp.txt"
    DoCmd.TransferText acExportFixed, "TblNewQtrTaxExp Export Specification",
    "tblNewQtrTaxExp", "\\CTFLAN\NETWORK\DB\" & FN, False, ""

    SumOfcurStateEeSIT is a field in the table and part of the Export Spec,
    Thanks in advance for any help.
     
  2. Loading...


Share This Page