FileCopy Problem

[rdemyan via AccessMonster.com]

I'm trying to copy a .mdb file from Computer A to Computer B. Here's the
simplified code:

If fso.FileExists(SourceFile) = False Then
MsbBox "Source file doesn't exist. Can't copy!"
Exit Sub
End If

If fso.FileExists(DestFile) = True Then
Kill DestFile
End If

FileCopy SourceFile, DestFile

But I'm getting the following error at the FileCopy statement:

Error #75 Path/File access Error

I typed in the code above, so hopefully there are no errors. The source file
definately exists (fso.FileExists(SourceFile) = True).

The SourceFile is not open. So I don't have a clue why this is not working.

I've only just started working with A2003, so maybe there's something I'm
unaware of, but security has been set to the lowest level possible.

Any help, ideas, suggestions are appreciated.

Thank you.

 

[rdemyan via AccessMonster.com]

Additional Information:

I tried reversing the copy process. Instead of from Computer A to Computer B,
I had my app on Computer A try to copy the files from Computer B to Computer
A. Exact same code, exact same file names (although paths were different) and
everything worked fine.

MAJOR DIFFERENCE is that Computer A has A2000 whereas Computer B (previous
post) is running A2003. So this is starting to verify that this must be a
A2003 problem??

Again, any ideas or suggestions are greatly appreciated.

Thank you.

 

[Marshall Barton]

I'm trying to copy a .mdb file from Computer A to Computer B. Here's the
simplified code:

If fso.FileExists(SourceFile) = False Then
MsbBox "Source file doesn't exist. Can't copy!"
Exit Sub
End If

If fso.FileExists(DestFile) = True Then
Kill DestFile
End If

FileCopy SourceFile, DestFile

But I'm getting the following error at the FileCopy statement:

Error #75 Path/File access Error

I typed in the code above, so hopefully there are no errors. The source file
definately exists (fso.FileExists(SourceFile) = True).

The SourceFile is not open. So I don't have a clue why this is not working.

I've only just started working with A2003, so maybe there's something I'm
unaware of, but security has been set to the lowest level possible.

I don't use fso so I can't analyze why it would say the file
exists and FileCopy can't find it, Maybe the file is
locked?? Maybe you're using a partial path??

Rather than tack on to an existing thread, I suggest that
you post your question to a new thread.

 

[rdemyan via AccessMonster.com]

Thanks for the response, but this is my thread and my second post is simply
additional information for the first post. So I don't know what you mean.

I've discovered the problem. It appears that it is a folder problem,
although I don't know what caused it. The folder on Computer A is not
accessible from A2003 on Computer B, but is accessible from Computer A using
A2K. I did not knowingly set any permissions or lock out shared use. I
don't even know what else to check for (OS is Windows XP Home Edition).

Moving the files and subfolders to a new folder solved all the problems, but
I have no idea what caused it in the first place.

I'm trying to copy a .mdb file from Computer A to Computer B. Here's the
simplified code:

[quoted text clipped - 21 lines]

I've only just started working with A2003, so maybe there's something I'm
unaware of, but security has been set to the lowest level possible.

I don't use fso so I can't analyze why it would say the file
exists and FileCopy can't find it, Maybe the file is
locked?? Maybe you're using a partial path??

Rather than tack on to an existing thread, I suggest that
you post your question to a new thread.

 

[Vlad]

Not that I care, but this was my thread originally ;-)

 

[rdemyan via AccessMonster.com]

Vlad:

I apologize if I stepped on your thread, so please explain to me how I did
that. I started this particular thread and mine is the first post. Is it
because I may have used the same title as a thread that you started earlier.
I didn't and still haven't checked. Let me know if that was what happened.
If so, how can I be sure that I'm not using a thread title that someone else
has used in the past.

Thanks.

 

[Vlad]

No worries - I have been posting from google groups:-

http://groups.google.co.uk/group/mi...abd9ce9057bc80?lnk=arm&hl=en#dbabd9ce9057bc80

You can see there the 2 threads together.

It must be something to do with the same titles of both threads. I
don't really know enough about the workings of usenet to know how you
stop that from happening, or what has actually happened but you may
find posting through google groups more reliable.

 

[Marshall Barton]

I am not the right person to deal with this kind of issue,
but it might have something to do with the share, if not the
permissions.

Your thread shows up in the middle of a thread that I have
been working on so that's why I responded. Some newsreaders
sort threads by the subject line so that may explain how
yours appears intermixed with another. Sorry about the
misunderstanding, but I had no way of knowing you had
started a separate thread.
--
Marsh
MVP [MS Access]

Thanks for the response, but this is my thread and my second post is simply
additional information for the first post. So I don't know what you mean.

I've discovered the problem. It appears that it is a folder problem,
although I don't know what caused it. The folder on Computer A is not
accessible from A2003 on Computer B, but is accessible from Computer A using
A2K. I did not knowingly set any permissions or lock out shared use. I
don't even know what else to check for (OS is Windows XP Home Edition).

Moving the files and subfolders to a new folder solved all the problems, but
I have no idea what caused it in the first place.

I'm trying to copy a .mdb file from Computer A to Computer B. Here's the
simplified code:

[quoted text clipped - 21 lines]

I've only just started working with A2003, so maybe there's something I'm
unaware of, but security has been set to the lowest level possible.

I don't use fso so I can't analyze why it would say the file
exists and FileCopy can't find it, Maybe the file is
locked?? Maybe you're using a partial path??

Rather than tack on to an existing thread, I suggest that
you post your question to a new thread.

 

[Marshall Barton]

Not that I care, but this was my thread originally ;-)

Vlad, now that I'm checking more carefully, I see that Andi
jumped into your thread with a related question as well.
With all the back and forth going on here, I'm not sure if
you received adequate help with your situation.

 

[rdemyan via AccessMonster.com]

Not a problem, Marshall. I had no idea that my thread is showing up in the
middle of another one. I can understand how this is annoying.

I am not the right person to deal with this kind of issue,
but it might have something to do with the share, if not the
permissions.

Your thread shows up in the middle of a thread that I have
been working on so that's why I responded. Some newsreaders
sort threads by the subject line so that may explain how
yours appears intermixed with another. Sorry about the
misunderstanding, but I had no way of knowing you had
started a separate thread.

Thanks for the response, but this is my thread and my second post is simply
additional information for the first post. So I don't know what you mean.

[quoted text clipped - 20 lines]