Moved a complicated DB from one Windows 10 PC to another Windows 10 PC - one major thing stopped...

[PetePetePete]

...working.



I'm going to do my best to explain it carefully. It has been a LONG time since I dug this deep into what I created a long time ago. I know the names for tables, macros, etc. are not professional... but it has worked for a loooooong time, and I can certainly fix that, but I *really* need to get this back up and running and retire the old machine.

The preface is that I have a db that imports data from two flatfiles via ftp these files are created in "batches" whereas data is collected on them, then once a day (sometimes more, sometimes less) the data is imported in Access, the two files are deleted, and two new files (same names) are created upon the first new entry of data... and repeat, repeat, repeat. There's more to it, but for purposes of this problem... I *think* that is the salient information.

Here we go!

I have a Form. On this form there is an "OnClick" that takes you to a Macro called "Download OL"
"Download OL" does a RunApp that runs a file on c:\MyPlace\Import.bat

The object of this file, Import.bat, is multi-faceted.

First: It renames the previously imported flat files and changes their extension to .bak (there are two flat files that the db uses) (this change is made on the PC side on the c: drive)

Second: It takes the new (not yet imported flat files) and changes them from .txt to .txt-locked so that there is no interference if new data is being submitted at the same time. (this change is made on the FTP side via FTP -s:filename.txt domain.com

The filename.txt file looks like this:

username
password
passive
cd /public_html/dir/dirnext/
ascii
prompt
rename 123.txt 123.txt-locked
rename asd.txt asd.txt-locked
mget 123.txt-locked
mget asd.txt-locked
bye

AND HERE IS THE PROBLEM...

It stalls/stops working at the mget command. It never downloads the 123.txt-locked (or the asd.txt-locked) files and puts them in the dir on the PC side.

That's it! That's all I need to know. LOL. How can I get the mget back to working? The funny part is that it works perfectly fine on the current Windows 10 machine, but refuses to work on the new one.

Sorry for such a long post for what must seem like a simple problem to you folks, but tracing it like this was the only way I could get there from here.

[Welshgasman]

Execute those commands manually on the errant computer.
Does ftp work on that computer?

[PetePetePete]

I am going to head to the office and try it. I don't have remote access to the new computer, only the old one... I assume you mean just going to cmd and trying to mget the file?

[Welshgasman]

Yes, just try everything manually, that is what I would do.?
I've just had a peek at my windows 10 features and there is no option for FTP like there is for Telnet. That was my first thought.

[PetePetePete]

Hold the phone!

Ok... so... I have another "newer" Windows 10 machine here... and get this... when I try to execute the mget it says, "Cannot find list of remote file."
yet... if I execute the same on the old Windows 10 machine it works!

So... what gives?

[Welshgasman]

So did the rename work?, look to see what is there?

[PetePetePete]

The rename wasn't the problem... that's on the PC side, so it works fine. The problem is with mget downloading it via FTP to the PC side.

[Welshgasman]

The rename wasn't the problem... that's on the PC side, so it works fine. The problem is with mget downloading it via FTP to the PC side.

Second: It takes the new (not yet imported flat files) and changes them from .txt to .txt-locked so that there is no interference if new data is being submitted at the same time. (this change is made on the FTP side via FTP -s:filename.txt domain.com

[PetePetePete]

Sorry. Yes, you are correct. It *does* do the rename on the server... (rename) ---- but it will not do the mget.

[Welshgasman]

Sorry. Yes, you are correct. It *does* do the rename on the server... (rename) ---- but it will not do the mget.

Has it 'really' renamed it though?, as that would explain the file not being found?

[PetePetePete]

When I ftp into the dir via Filezilla, the file has been renamed.
When I try the "rename" command alone, it works.
When I try the "mget" command alone, it does not work.

[Welshgasman]

Out of ideas then, sorry.
Perhaps just check Windows with sfc /scannow

What ftp are you using? as a few are having the same problem and error message at https://forums.cpanel.net/threads/cp...update.677841/

[PetePetePete]

Out of ideas then, sorry.
Perhaps just check Windows with sfc /scannow

What ftp are you using? as a few are having the same problem and error message at https://forums.cpanel.net/threads/cp...update.677841/

Thanks... brutal, I'll likely have to use the "broken" file and then move the two file with FileZilla to the PC side dir.

I'm using FileZilla... (note that this issue has nothing to do with FileZilla, and this is being done via cmd (command prompt))

There MAY be something to running cmd as admin, however I haven't been able to have it run cmd via Access 2003 as an admin. (Only if I go in via the Start Menu and type cmd)...

[Welshgasman]

Have you tried Get as you are copying individual files and mget appears to be for multiple files with a wildcard?

[PetePetePete]

I have not... but I certainly will!