VB Forum / Database Access / January 2007

I have been out of the programming world for a little while. I think am
attempting to something quite simple. All I want to do is create a VB6 Exe
file that takes a MS Access 2003 mdb file, opens a table and modifies the
field names in it.

To anyone who can help:
I have a form, in datasheet view, I wrote code (in ADO), listed below,
to delete a given record.  The code is placed in a module, and called
by simmilar forms.  For this paticular form, when I initate the code,

What is the best way to convert whitespace to NULL when inserting data into
a SQL table? I have a file that I'm parsing parts of into a UDT. Sometimes,
the fields I'm parsing out of the file are blank, so that field of the UDT
is set to "". When I insert this into the SQL table, ...

I am badly confused as what to use dao or ado ???
i tried puting one ado control it works fine, but i have one combobox in
which the data is fetched from other table to insert in to the other table,
so i need two ado controls, but one of the ado control is getting disabled

I take a backup with the folloeing commands:
  cn.open connectionstring
   sqlstr = "BACKUP DATABASE uruntakip TO DISK = 'd:\backup.dat' "
   cn.Execute sqlstr

I'm trying to get a POS app I wrote in VB 6 to work on a thin client using XP
Embedded. My connection string utilizes the "Microsoft.Jet.OLEDB.4.0"
provider and I've read that XP Embedded does not use the Jet engine.
What should I use as my new provider and if using a different ...

I have a combo box populated from one database table, now i want to use the
value of that combo box to be passed as the parameter to another record set
so that the data gets filtered with the value of that combo example which i
use in asp/vb

i am doing a project in VB whose backend is access. i am doing on zodiac
sign.while selecting  the month eg-20th march to 20th april it should display
the particular zodiac sign. i am getting a error data type mismatch criteria
expression.

I'm trying to use ADODB Recordset Save method with adPersistXML in my
Access 2k application which will be then opened with ADODC / Datagrid
in a VB form (disconnected).
I'm using ADO 2.6 if it has anything to do with this.