[AccessD] A2K: Another Trasnfer Database Q

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



More information about the AccessD mailing list