VB Forum / Database Access / October 2004

When I open an Excel ODBC connection, I cannot edit the Excel sheet in
Excel. Excel reports that the "filename is locked for editing"
If I open the Excel sheet before the code executes then everything works
okay and the connection appears to be read only.

IS there a way of copying (or Pasteing) a form and all of it's information
into a email and sending it out.
Eddie.Isenhour1@wachovia.com

I posted this on .sqlserver.security under the same name and Tom Moreau
suggested I post here and see if you all have any ideas.
I have a production and development system both running on one PC under W2K
with SQL7sp4.  One Web Service can access and update the database via ADO

OK, still battling with getting formated text into SQL Server.  I think that
a Rich Text Box will fill the need, so I am working on that.  I am actually
having a problem with the query to send its contents to SQL Server.
I have a Rich Text Box on a form called "rtb1".  I am trying ...

Can anybody please help me with this error I'm seeing when my VB6
program tries to log into an Oracle database - bearing in mind this
has been working for years!
The program has always used Microsoft's drivers and, whenever a new

Before saying my prob let me explain what my program have.
My One form have 2 Image Control that displayed as banner (i.e. displays 10
jpeg files after each 2 secs).
On same form , 8 image controls with fixed jpeg file referenced only once.

I'm persisting an ado hierarchical recordset to xml and cleaning it up. The
end result looks something like this:
<mytable>
 <record id = 1 name="A">

I have the following code in a small module to allow the user to build up a
connection string to access a database.   It works fine against an SQL
server connection on my machine (win2k pro).
However, when executed on one of the clients win2k server boxs it does not

When I set references in VB5 to interact with a .MDB file in access 2004
format, I get error messages saying that the new references conflict with
references already in use.
Without these references the programs won't recognize the Access 2002

How do you parse words from a string.
I need to create a record for each word in a sentence.

Can anyone tell me how to save an rtf field into a sql column?
I am using an update statement to updat ethe record, which is read out of the rtf control, but it seems to have problems with the rtf formatting. When it hits a ' mark it misreads it as the end of the text.
Cheers
Adam

I am working for a company who have a access database. This has been ever
growing larger and now it's become apparent we need to convert the DB to a
server system. The problem is we are trying to write code for this
conversion as we do not have sequential ID numbers but random IDs ...

I have an Oracle Database table and an Access Table with identical definitions (the DDL was exported from Oracle and data types were
corrected as required).  I have the following test code:
Public Sub TestSwitchConnection()
  Dim cnOracle As Connection

I have a function will will being called by 2 classes
One classes will supply a normal connection while another class will give a
under-transaction connection
i would like to know how can i read the connection status so that i can know

I am hoping someone could provide me with an efficient example of how to use
the a DataAdpter in VB .NET code to connect to 2 different MS SQLS databases
and run a query across the databases.  I want the ADO DataAdpter, reader,
whatever to populate a single datatable with the ...