VB Forum / Database Access / June 2008

I have a problem with my vb6 application and MS Access database. The
database has only one table. The application inserts data to this
table each 1-2 seconds.
strQry="INSERT INTO table (...) VALUES (...)"

I've developed a VB 6.0, SP6 program to import a fixed length fileds, ascii,
text file into a new Excel 2003 workbook.
I programmatically design a recordset and import the text file into the
recordset using these kinds of statements:

Could someone explain what would be the easiest way to display a
visual basic program as a simple web site application. For instance, a
simple online calculator.
Thanks!

I have a table with a primary key.  In MS Access, when I insert a row, the
primary key is automatically generated on the insert statement.  However, in
SQL Express 2005, I need to explicity specify a value.
Is there a way to set the schema to do this automatically?

My problem is rather simple to describe but maybe hard to code:
I need to store an integer array into an SQLite database. And I must be
able to search for records that match a certain "ending". I know it's
not a string so I cannot speak about "ending", but I hope you know what

Am writing a new application that would work with the database. The
application is pretty simple. But, since I'm a newbie in vb I'm having
problems with getting results of the SELECT statement into a window.
i use an AdventureWorksLT database. I need somehow bring the result of the

Hi
does any one out there know how to build the Postgres SQL connect string for
ADO connection?
thanks any one who can help.

I have a issue updating a sql server compact 3.5 with code that works fine
with sql server.
The following extract updates the required table in sql server but does not
work for the compact version?

Hello, I built a database in Access 2007.  The company recently switched from
Access 2000.  I build a ODBC connection into a view only SQL database (done
many times previously in 2000) and built my database.  When completed I went
over to a co-workers computer to show the new ...

This statement is executed in SQL Query Analyzer with no problem:
UPDATE [Partial] SET InvoiceDate = null WHERE PartialID = 34855
I would like to run ADO command with that text. It fails. What should I use
instead of null in the CommandText string?

How do I, using an SQL statement only, get one row from a recordset.
I need to get at random rows one at a time.
Example: SELECT rownum 5 FROM table
-Lou