VB Forum / Database Access / August 2006

I'm developing an Office-integration with a document handling system and
Microsoft Word + Access in which the customer want to have full control over
the data to use.
Therefor the data and some images such as logotypes is placed in an Access

I tried using the windows winsocket control on my Access form and place
the recieved data in a text box.  I got it to work but the data is
coming accross like ÿþ%ÿý and I cant use that information.  Is
there a way to descramble this.  I'm thinking it might have to do with

I'm trying to create a combo box that has the only the field names from
a table in it and not the items in that field.  So for example I have a
table with 40 fields in it like Account#, Name, address, phone # etc...
I want to click on the combo box and have the option to choose a ...

I have a little VB6 program that dumps the schema of an Access 97 database.
The following lines of code are relevant.
Private m_wsDb As DAO.Workspace
Private m_db As DAO.Database

I am creating a standalone database application that will not be connecting
to a remote computer.  Would it be better to create an SQL Server database
for my program or just use a local data file?  I have tried to create an SQL
Server database from within VB Express 2005, but it ...

I am using ado (not ado.net) to query a mySql db, there are thousands
of records in this db, I know I can limit the amont of records
returned via sql or via setting
adoRecordsetObject.MaxRecords

Hi, I am new to ADO objects, but I am trying to open a record set in
VBA (Excel to be exact).  I have set up the following quick sub for an
example of what I have done.  KillAll kills all the connections i'm
working with, admincncn, adminrset, adminrset1 are a adodb connection,

Could anyone help write an SQL statement to take this:
Table X (  key, Money, TheDate, first, last, ...) =
( 1, $1, #jan 4, 2006#, 'fred', 'willard', ...),
( 2, $4, #apr 1, 2006#, 'emanuel', 'lewis', ...),

I am using ADO to read/write to a textfile.
Using "SELECT * FROM" and  "INSERT INTO" works fine.
But UPDATE and DELETE don't work??? But why!
Dim Conn As New ADODB.Connection

I have a need to rename a table in an Access mdb file that has been installed
on client machines.  I am starting to realize I haven't the faintest idea how
to work with the database objects themselves.
I have looked through this forum and MSDN and can only find an example of

Hello.  I need to be able to create a column in an Access table that has the
"Ole Object" data type, but I need to be able to do it using SQL syntax
(ALTER TABLE or CREATE TABLE).  For the life of me, I can't find any
information on how or if this can be done, which means to me ...

I using Data Environment Designer for access to my odbc database
When I build new SQL query for command, I must set type of join my tables
(one to one or one to many) but I can found such properties in  Visual
Database Tools for VB 6.0.

I am writing a VB6 application where I am trying to write to a SQL Server
2000 table.  One of my fields is defined as text because it may be longer
than 8000 characters.
The table layout is:

I need help with creating a Telnet form in Access 2002.  We currently
use a telnet program to access data on our main host system.  We have
created an access data base work through accounts in this system, but
we also have to have our telnet session up to input data back into the

I have an intermittent problem from the below sample code in my BATCH
program, I having 1 intermittent error as the adors.state will return close
before populate my result and i can not capture any ado error. Any idea how
this happen? will that be connection problem? It should ...