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...

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...

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...

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?

I wish to create a Cdonts email object in a vbs file and have it execute on command (not from an ASP page) but I am not sure how to write it. I put a small app together and got no errors nor e-mails. Any clue? dim myMailer set myMailer = server.createObject("Cdonts.NewMail")...