VB Forum / Database Access / July 2008

I have a simple VB6 program which is working fine. I have a form with an
ADODC control on it I call "AdoCalendar". One of the properties is the
"Connectionstring". Amoung the items in the string is the location of my
access .MDB file.

Please forgive me if I am asking this question in the wrong area.
In my app I am connecting to an Access database that contains a table with
an address field.
I am trying to sort the table by using "SELECT * FROM members ORDER BY ADDR"

I am using Access and want to make a ADODB connection, but I do not
want to type a path for the Data source -
Instead I just want to refer to "Current Database" ... not "Data
Source = C:\Name.mdb

I'm using the following code to append a new field to an existing
table in an MDB file.
  Set td = db.TableDefs("MainData")
  Set fld = New Field

I am writing some code that will read an Access 2000 database
structure using ADOX and store the details in a set of tables.  I have
it mostly done but I have noticed that when reading through the
properties of the columns, the Unicode compression property (Jet

I have a strange problem that I'm really having a hard time fixing.
My project runs on a PC and uses an Access database on the same PC.
There is a datagrid connected to the database via an ADODC data control.
My code will modify the contents of some fields using the code below.