Search results for query: *

I am interested in knowing how to open a MS Word document stored in Access 2000 as an ole object. I get "type mismatch" error with the following code.. Dim oRst, sQuery Set oRst = CreateObject("ADODB.Recordset") sQuery = "Select * FROM tblPOW WHERE tblPOW.[Current] = true" oRst.Open sQuery...

Thanks for your response. Yes the recordset value does not represent a string. It is an acutal document stored as an ole object in the database and the error "type mismatch" is correct. What I don't understand is how to use the word.application object to open a stored word document in MS Access.

I am interested in knowing how to open a MS Word document stored in Access 2000 as an ole object with vbscript. I get t type mismatch error with the following code.. Dim oRst, sQuery Set oRst = CreateObject("ADODB.Recordset") sQuery = "Select * FROM tblPOW WHERE tblPOW.[Current] = true"...

I am trying to open a connection through an ASP page via an ODBC connection to a secure Access DB and keep getting the same message. [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or...

SELECT SYSDATE FROM DUAL WORKED! Yes Hunt has access to the objects. As I said I can open a linked connection to the DB and tables in Access 2000.

I have a DSN connection to an Oracle DB. I can connect to the Database no problem but when I try yo reference a particular table in my query I get the message "TABLE OR VIEW DOES NOT EXIST" Set oOracle = WScript.CreateObject("ADODB.Connection") oOracle.Open...

I have an Access 2000 database that has a field set to Yes/No and formatted as true/False. Nothing, I say nothing works when I try to read the fields value. i.e Dim oRst, sQuery Set oRst = Server.CreateObject("ADODB.Recordset") sQuery = "Select * FROM tblPOW WHERE tblPOW.Current...

I am interested in using the MSCOmm control via a web page to control a remote camera thru the host computer serial port. Does anyone have any experience writing similar code? How would I Set my control with the createObject property? I am not well versed in ActiveX excluding ADO and have never...

I wish to turn off the automatic highlighting of text in a multi tabbed form text box. When i switch between tabs it automatically selects all of the text in the text window. Any idea how to do this?

I am writing some vb code to log into Exchange and extract information from the calendar. I need a way to get around the Macro Security Warning. I would like to sign the code with a certification and have exchange accept signed scripts. Is this possible? I must note that they will probably not...

I am writing some vbScript code to log into Exchange and extract information from the calendar. I need a way to get around the Macro Security Warning. I would like to sign the code with a certification and have exchange accept signed scripts. Is this possible? I must note that they will probably...

Can anyone tell me the implications or Pros/Cons on keeping a DB connection open via the Global.asa? This is on an Intranet.

I am interested in finding out if a reference to the security file can be included in an ADO connection string. I have not seen any examples nor found on MSDN any reference to it. sConn = "Provider=Microsoft.Jet.OLEDB.4.0;USER ID=guru;Password=TheGuru;Data Source=\\rdpublic\rad\Rad.mdb"

I am trying to access an Access 2000 DB with ADO that is restricted by a Security file. No matter what I do I can't Open the DB. If I create a DSN it works, but then when the Queries in that DB (which I am referencing in my SQL string) access table/queries in another DB I hit the same wall...

Thanks but that still would not work. I guess i'll have to find a different way to get at the data.

Pinging worked fine but your #2 connection path resulted in "error 3706 provider cannot be found". The ODBC connection works fine. My original connection to the DB was a File DSN that worked great. sConn = "FileDSN=ls.dsn;" & _ "Server=LsUnits.world;" & _...

I have a connection to an Oracle DB and it works fine. Once I try to create a recordset though, I get the following error. "Ora-00942 Table or view does not exist" I have an Access 2000 odbc linked connection to the same oracle DB and I know what the table names and field names are...

I have some hardcoded ADO connection strings in an ASP page on my web server that connects to an Access DB. I aslo have Access 2000 installed on the server. I joined the networked Workgroup file directly from the Web server. The problem is, I keep getting an error.... Cannot start your...

I am querying an Access DB that has some of the text/memo fields data in Paragraph form. Question is, why do I loose my formatting when returning data to my web page? i.e inserted into db as.... Sentence One Sentence two Returned from db as... Sentence One Sentence Two

I have a modem installed on win com 4 and wish to set it up on linux ttys3/com4 but there is no ttys3 device link file. How do I create one or get my system to do it?