Recent content by kdefilip

Well, the process goes like this. A vb script starts and passes the dsn to a word merge doc. The word merge doc, using the dsn, queries an access mdb file over a mapped drive to a file server. The mdb file has linked tables back to some flat files on another system through odbc. However, for...

Yes, very helpful. If you have a moment more, could you look at the DSN string they are using and first tell me if you see something wrong other than the timeout of 5. And also if you would suggest a better method or string to accomplish what they are doing? I notice they are using fileid...

Yes, I agree. It may be the way to go. However, I don't know enough about connection strings, especailly ones that are being passed to a MS Word mail merge doc. I'll have to keep looking and see if I can find docs on it somewhere. Thanks.

Yes, I'm there now. Looks like they should be using a DSN-less connection. I can tell by the timeout=5, that this was created during an older version of MDAC/Jet as the timeout changed from minutes in <2.0 to milliseconds in => 2.0 - clearly this is a problem, but some of the other stuff in...

Yes, this is access 2002 using Jet 4.0. However, I believe there may be issues with this DSN string, but I don't know enough about it to be sure. It looks like they are calling an odbc driver (file 15??), but this is sure a weird way to go about it.

Yes, I will try to find some docs. The DSN looks like this - which is a little foreign to me. "DSN=MS Access Database;DBQ=" & strDocumentPath & "Access_Database\" & "myfile.MDB;" & _ "DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;" _ , SQLStatement:="SELECT * FROM...

Hi I assumed that was the case, but do you have any way to verify that, a link at msdn/MS. I need to confirm this to a reluctant audience.

Hi. I have been looking into a process that is confusing me. Server A launches a MS Word MailMerge Doc which contains a DSN to a mapped drive on Server B Server B has a copy of an Access DB at the mapped drive location. As I watch this process on both servers, never do I see a process...