Search results for query: *

In the end I wound up creating a .cmd batch file to which I called with a scheduled job. -Faris "Eagles may soar, but weasels don't get sucked into jet engines.

PrgrmsAll, I have been dealing with an issue along these lines lately. And while I still seem to be having some problems with it I believe that I am close to a solution and will post it here when I have it solved. The route that I am going is to create an ftp.cmd to execute. I found the...

I use Smart FTP to manually perform this process at this time. This is what I am trying to get away from. I don't know much about creating batch files etc.. so I am trying to use the activeX script as this is the way it was done in the past. Unfortunately the old way was using an http...

It is always disheartening when you search the forums and find the exact problem you are having, but then the original individual submitting the problem drops the thread. Anyway, this is exactly the same issue that I am having. Mine is being caused by a Query. SELECT [Master Table - Key...

It's nice to learn about the 'Disconnected Edit' feature, but I am getting an FTP task error for invalid string format for source file name. I am afraid that part of the problem is I don't see where I can tell the FTP Task that it needs to CD or CWD to ../docent to find the file. Thanks, Kevin

The way the FTP server is set up it doesn't allow me to directly declare the path to ../docent dir. If I try and view the files through the 'files' tab on the FTP task, I can't see any because of the way the security is set up on this FTP server. Unfortunately, this server is my only option to...

I am having difficulties getting my script to retrieve this file. It needs to change directories once it connects to the FTP Server in order to retrieve the file. This is th script I am trying to use. Any suggestions would be very welcome...

never mind, I just update the connection settings with adding the password and marking it for allow saving. I guess the only problem is that it doesn't track individual user changes, but that should be okay since the original db didn't do that either.

The access should be the same as for any kind of ODBC connection. The problem is that if I set it up for NT Logon authentication. It seems to be failing for some users. If I set up an account for the connection, I would need to do this for every individual user. Isn't there some way to...

I am having trouble creating a way for my .adp file users to connect to my SQL Server. Any ideas on how to make this work?

Bob, You are the bomb, but all I really needed to do in access was add the LIKE @Process_Team to the criteria. Thanks All! BTW, I will be starting a new post in a moment about getting security access for my .adp users to my SQL Server.

I was doing all of this in the Record Source for the Report, but i created it as a query now and then referenced the that query from the Report Data:Properties. Unfortunately, it still seems to be returning a blank report instead of asking me for values for Process Team etc. New code, notice...

PHV, this is the full Where statement I am using: WHERE ([Lookup Table - Process Team].[Process Team] LIKE ['] & [Process Team?] & [']) AND ([Master Table - Process Information].[Process Number] LIKE ['] & [Process Number?] & [']) Note: Access is replacing the "'"...

I have a report in Access that calls for something like this: WHERE ((([Lookup Table - Process Team].[Process Team]) Like [Process Team?]) But I am making the DB into an .adp and the design view for my report doesn't seem to support this kind of query. It comes up looking like this at best...

I think what you are really looking for is to check if: - This version of w3svc shows that Hotfix MS04-021 was installed. - Because there is a known issue with Microsoft Windows NT 4.0 server. It is caused when an ISAPI filter registers for the SF_NOTIFY_PREPROC_HEADERS notification and...