VB Forum / Database Access / November 2005

I have and Excel spreadsheet with a VBA macro. The macro calls a dll
which in turn connects to Oracle database using ODBC. This causes the
Excel spreadsheet to crash. Has anybody experienced such a problem and
how did you resolve it.

Does anyone know how I set a reference to a given field of an Access table
through code when I know the string value of the table?  I would think it
would involve the "SET" statement but can't figure it out.  I set up a
standard connection and open the recordset using:

Trying to learn ado/adox
Creating a class to simplify calling code and assist in learning process.
example of a couple methods/propeties
.TableExists    (method to determine if table of given name exists)

Using Visual Basic 2005 Express, I have a form with a DataGridView control
on it.  The DataGridView Dataset is a SQL Express 2005 db (1 table, 5
fields). If I Start debugging (F5 key) the form builds, and the data is
shown in the DataGridView just fine.  But if I run Debug, and ...

I wanted to use this grid to display data in hirechical order but done
know how this is to be done please help

I would like to implement optimistic concurrency where I retrieve the
timestamp of a record in a table with a stored procedure and save the
timestamp value into a vb.net variable. This represents the original
timestamp for the record. When a user updates the record, I would like ...

I'm building an application, using DAO with VB6 (sp6) and I encountered the
following problem:
I open a recordset (rs), select a record by using e.g. SELECT * WHERE
MYFIELD="123".(placed in a string)

I am writing an application in VB6  that makes regular calls onto an access
database.  When i run the Sub Main I could set a variable to store the
connection string.  Would this speed my application?  Also in the same vein,
i could create an ADODB connection in sub main and then ...

Hi, i am using the function below to determine several properties of
each field in a recordset and all is working well. My problem is that I
dont know how to find the default value of a field. Does anyone have
any code suggestions that would get me the default value

Hi, I am simply trying to align or "justify center" my text fields and
labels.
I see no property that addresses this.  Am I just not seeing it?
Thank you

how can i replicate the access database using VB ?

Hi, i am using the function below (visual basic 6) to determine several
properties of
each field in a recordset (SQL server) and all is working well. My
problem is that I

How can I retrieve the values from a particular Sql Server DSN in VB 6 ? I
want the UserName, password, the ServerName and the Default Database Name
from the DSN. Is this possible?
Thanks,

i'm using dao for the first time to connect to a MS Access db.  I've been
following the MS example for a very basic query. This is the MS example:
The following code shows the process of creating a recordset from a
querydef:

I have troubles running VB6 applications on XP-computers that not have Visual
Studio or Access installed. All dll files setup add to the project are
installed and registered Ok. When I have installed Microsoft Access the
application works just fine.