Charlotte Foust
cfoust at infostatsystems.com
Tue Apr 6 19:25:12 CDT 2004
Are you deleting the link before you try to relink? I would expect it to fail if you moved the file *anywhere*. That's just the way Access links work. Are you using the entire path and filename in the filename argument? Charlotte Foust -----Original Message----- From: Darren DICK [mailto:d.dick at uws.edu.au] Sent: Tuesday, April 06, 2004 3:51 PM To: AccessD List Subject: [AccessD] A2K: Another Trasnfer Database Q Hello all When I try to import or link to a DBF or XLS file in the root directory all is well. When I move the dbf or XLS file to ANY dorectory/folder the import or link fails. Access spits up a long error message with Error Number Saying that the path is invalid. That I should go and check that it exists etc. Of course it exists I just created it for testing as well as using pre-existing directories. The Docmd.Transfer works - why would it fail when I use a folde? Yes I have tried quotes around the path and xls specs Any taker? Many thanks in advance Darren -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com