Search results for query: *

I did link directly to the .mdb file and the computer has Access on it. That's why I am so baffled. I can save it to my computer and it will run, but it will not run across the network.

I had just tried to open the file. The computer was downloading and was about to open the program when the error appears.

I did think of that, but when I tried it I got the error: "There was an error sending the command to the program" Any other ideas?

I was wondering if anyone had any ideas on how to run a locked Access DB in IE. I have been given a 3rd party read-only locked DB and asked to give everyone access to it through our Intranet.

Thanks very m,uch for all your help.

By the way, I did try the query analyser and that returned the same error. At least we know it's not the code.

We know that we can connect to the server using an ODBC connection using the AS/400 software. Is there any way that you can think of to make that connection using VB code?

Unfortunately the current login won't work on the Server (which is remote). I tried using an obscenely long timeout (60, 120, 240) to see if the error came up before timeout, but it always shows up right at the timeout.

I am running Windows NT and MSSQL_SECURE_LOGIN is False. The value is set in my constants section.

Yes, the server is running. I did the test you recommended and that says it is running. Any ideas?

Do you have any ideas why I would get the same error even though the user name, password, and host are all correct? I'm not familiar with SQLDMO, but it is part of the program I am trying to use: Set dmoSrv = CreateObject("SQLDMO.SQLServer") If MSSQL_SECURE_LOGIN Then...

I am trying to create an index number using values in another table. I need to be able to concatinate multiple values and store them as a single value in a table. For Example: object type - wm street index - 173 Block number - 200 Incremental # - 001 creates a value of wm173200001 to be...

This was just what I needed. Thanks!

I am trying to allow users to search a memo field using a keyword, so I need to be able to add the LIKE "*comments*" to the query criteria, but comments is from a form. This is the code I came up with, but it does not work criteria: Like "*[Forms]![FormQuery].[comments]*&quot...