VB Forum / Database Access / November 2003

Anyone can suggest me a good DB design tool which can show ER diagram with
column name, description, data type, index info. etc...
Thanks
Douglas

Hi all..
I've never used this before.. Need help from you guys..
How do I create a progress bar in VB that shows the status of data copying
process?

I need to know if inside a grid, I can do a dropdown menu
in a particular field showing values from another table.
This will validate the inforamtion and it will also
streamline data input. In the same token. In another

I'm trying to develop an application witch connect to a
shared Access database on a server in a LAN; this
application should run in a lot of client, each of them
using the same database in the server PC. I'm NEW about

I'm at the end of my tether - if anybody can put me in the right direction,
I'll really appreciate it!
I need to access run a SQL statement to get a recordset - Nothing special.
But the table is a Clipper table and it has 274 fields. The MS FoxPro driver

I am writing some code in VB6 for sql 2k database. can
anyone tell me how to open enterprise manager from vb6 so
that users don't have to go to
start->programs->sqlserver->enterpriseManager

How to work Interbase transactions with ADO???

can someone tell me how to insert date into sql2k
database from the vb6 app.
here is what i am trying to do
========================================================

Hi all..
Can anyone show me the coding to copy a file from 1 folder to another folder
in VB?
Say I have a filename entered by user stored in a variable "strFilename"

We have a client in Germany running Windows XP SP-1
(German) and Office 2003 Pro (German). They are using a
VB6 app that uses an Access 2000 database via ADO/Jet.
This had no problems until after he upgraded from Office

I am a new VB6 programmer, reading books published
between 1996-1999 that name several different data
controls: DAO, ADO, & ADO in a data evironment. Which of
them is the best and most flexible data control to use?

I have a dblist (dbldate) where the field is a date field
from an Access 2000 table.  When I select a date I want
the program to fill a text box with the contents of
another field in the same record of that table.  How do I

... create another recordset (in another connection) with the source being a
recordset
set con1 = adodb.connection
set con2 = adodb.connection

My program uses a Dataenvironment to connect to an access database(using ADO). I used MS jet 3.51 to connect, but had to change to MS Jet 4.0. Now my Update and insert statements worked fine while i was using Jet 3.51, but now they are giving errors. Should I be doing them in a ...

I have an open recordset called andrew that is connected to an Access 2k
database.
I am opening a new connection to another database thus:
Dim oConnSAS As ADODB.Connection