 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms Programming / April 2006FileCopy Problem
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. 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. >I'm trying to copy a .mdb file from Computer A to Computer B. Here's the >simplified code: [quoted text clipped - 25 lines] > >Thank you. >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.  SignatureMarsh 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 - 8 lines] >Rather than tack on to an existing thread, I suggest that >you post your question to a new thread. Not that I care, but this was my thread originally ;-) 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. >Not that I care, but this was my thread originally ;-) No worries - I have been posting from google groups:- http://groups.google.co.uk/group/microsoft.public.access.formscoding/browse_thre ad/thread/40ee587f9c46a5b4/dbabd9ce9057bc80?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. >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. SignatureMarsh MVP [MS Access] 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. SignatureMarsh 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. [quoted text clipped - 20 lines] >>Rather than tack on to an existing thread, I suggest that >>you post your question to a new thread. 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 [quoted text clipped - 11 lines] >>>Rather than tack on to an existing thread, I suggest that >>>you post your question to a new thread. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.