Recent content by beruken

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.