VB Forum / Database Access / September 2005

If I want to update a record in a SQL table (MS Access FE), is the most
efficient method to create a server-side cursor and use the ADO update
method, or simply write an UPDate SQL statement?
TIA

Please...anybody can help me.I want to made application that open
database access on Network.It used ADODB connection object, but I don't
know connection string to open it.
maybe...someone can help me?

Below is my SQL Shape, I know the problem, I do not know how to overcome
it.
[INV ITEM KEY] related to [Trans Item Key]
I need to put a 'WHERE' clause in the ChildCMD which is like:

I'm trying to delete all indexes in an Access table, and then add new ones
based on an ADOX.Table that I have defined.  I am doing this because my
client sometimes messes with the database they are releasing to the
customer; and also because when providing updates, table ...

    Hello Guys
I'm having a gard time displaying a table's content in the datagris using
the designer.
Here's what I did:

I have 2/different MDB database but in both the database I have a column
called "company" and
now I want to loop true this 2/columne to see if there is missing any
company in the both tables, if' so the

I have a situation where I am trying to sort a recordset by the column
"ORDINAL_POSITION"  The problem is that I get the error:
"Run-time error '3251':
Current provider does not support the necessary interfaces for sorting or

I am trying to get the records for all the name starting with a "K".
So, I use this sql on a RecordSet but I get nothing back.
Select a,b,c from tbl
Where a LIKE 'K*'

Anyone else using SQLite with VB Classic?
~ Concerns:
* with Litex, I would have to provide a Setup or else have the users run a batch
file to register the DLLs

How can I paste a bitmap image in clipboard to an Access field using VB?
Thank you in advance.

Hello!!
My application uses DAO to access MSDE jet database (.mdb)I want this
applicaton to execute on 64 bit platforms too. I understand that DAO is
not supported on 64 bit platform and hence I want to migrate from DAO

I am in the middle of an application that extracts the Schema information
from an Access Database so I can make a SQL Server version of the database.
The problem is that using the ADOX catalog returns the columns in
alphabetical order instead of the order that they appear in the ...

I am getting error 3265 (Item cannot be found in the collection
corresponding to the requested name or ordinal) when executing  the
following code:
Set rec = New ADODB.Recordset

please suggest me how to done backup for my database. The idea is like this.
I have one database named abc.mdb. So, when i clicked one button, such named
BACKUP, the abc.mdb juz now made backup and rename it as abdc_1.mdb. But the
original database named abc.mdb is empty with ...