VB Forum / Database Access / October 2005

I'm trying to create a trigger with a Visual Basic program.  I generate the
SQL statement in VB but when I execute it, the command times out.  I can
take the exact same string that I'm passing in my VB program and paste it
into Query Analyzer and it works without any problem.  I'm ...

Hi...
   I am trying to write the contents of a recordset to an existing table in
the same database as follows:
Set RSSingleTestData = Access.CurrentDb.OpenRecordset("Select * From [Test

Is Microsoft Visio for Enterprise Architect a better data modeling tool or
Erwin better? The column datatype is not show on the table if created using
Microsoft Visio for Enterprise Architect?

I've tried everything I can think of and nothing seems to work.
If I don't have a password on the database, everything works fine.
If I put a password on it,
I get -2147467259(80004005) could not find installable ISAM.

I apologize for the length in advance, but I wanted to get all the
things I've tried and some background info on the problem...
I have a VB6 application talking to a SQL Server table through an
Access linked table, and in some cases, I get the following error:

I have a MySql database. this database has two tables (customers an
Invoice
s).
I created a VB .NET application which allows me to access the database

I have downloaded the final production version of VS 2005 pro after testing
with Team version. I wonder if I've been screwed or if it's just too early on
a Sunday morning.
It seems to me that it was relatively trivial to generate a dataset from an

Dear sir/madam
When I logon to windows 2000 server it display the message "Local policy did
not permit you to logon interactively". What should I do to logon
sucessfully?

hello every body
now I have a problem with vb and MySQL 5
when I write
rs.AddNew

I am trying to retrieve a field "DESC" from a table in a DB.
If I send my Select statement is "SELECT * FROM Table" I get a bunch
of fields that I don't want. If I use "SELECT DESC FROM Table", my vb
program shows an error in the statement while trying to open the

I'm using a data aware class that reads records from a text delimited text
file and i used the msdn guide for that but for my program i need to have
the program load info from the text only from  a certain line in the text in
which the field value in specific column is equal to ...

I am collecting data from multiple servers and dynamically setting the data
source by passing a new IP address.  The first one connects fine but when teh
second connection is opend I get a "Object reference not set to an instance
of an object."

Is there a way to log to file the SQL statements on ADO
Recordset.Open/Connection.Execute calls?
Let me expose the scenario: I have an app running on several clients, and at
a specific one it's raising some errors, which I think are caused by a bad

hello every body
now I have a problem with vb and mysql 5
when I write
rs.AddNew

hello every body
now I have a problem with vb and MySQL 5
when I write
rs.AddNew