Darren DICK
d.dick at uws.edu.au
Tue Apr 6 21:58:45 CDT 2004
Hi Charlotte Yes I am deleting the link before I start using Docmd.DeleteObject blah blah Re the file being moved any where, I can move the file anywhere and 'redo' the link using the new path, so long as the path is in the root directory (C:\) IE I can change the name of the file from SIDS.dbf to S_ids.dbf or whatever, but it must stay in the root directory. If I move it to "any" directory other than the root directory (C:\) it fails eg C:\ABC\SIDS.dbf <sigh> I dunno ----- Original Message ----- From: "Charlotte Foust" <cfoust at infostatsystems.com> To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> Sent: Wednesday, April 07, 2004 10:25 AM Subject: RE: [AccessD] A2K: Another Trasnfer Database Q > 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 > -- > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com