[AccessD] A2K: Another Trasnfer Database Q

Darren
What's the code? Have you tried specifying the folder in the 3rd parameter,
then just the dbf name in the 5th?

-- Andy Lacey
http://www.minstersystems.co.uk 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
> Sent: 07 April 2004 03:59
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] A2K: Another Trasnfer Database Q
> 
> 
> 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
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
>