When running MS Acess97 database on a server from a shortcut on the desktop, I am trying to import a csv file from the desktop using docmd.transfertext. This works on another PC but not on the networked one. The standalone is using XP Home SP2 and the networked one is using XP Professional. I'm not sure which server OS. This is the code:
DoCmd.TransferText acImportDelim, "", "csv_imported", "c:\exports\rac.csv", True, ""
Start Free Trial