VB Forum / Database Access / April 2008

My company has a VB6 application that accesses SQL Server 2005. Our
consultants demo this application from laptops that have SQL Express
installed. Periodically we need to repopulate the "demo" databases with data
from our development server. This should be done by the ...

I am working through some performance issues with regards to Insert and
Update procedures using a global connection object.  During the first
lifecycle of my project, I used an activex dll to store all my classes and
within each class they use this global connection object to ...

I have a fairly simple program I'm writing in VB6 to do basic project
scheduling.  It runs just fine on my computer.  I've created an
install set using the package & deployment wizard.  Here's the
problem... it only works on SOME of the computers I install it on.  I

I am using Visual Basic 2008 Express and doing a tutorial online. Reinstalled
Powerpack but still can't see this control in tools. All I see is the Printer
and Pointer controls. The video tutorials says this should work with 2008
Express VB.

Ok I admit semi-defeat. I have a basic script which snags files from a
temp location and stuffs them into a database. It appears to work
wonderfully every time except something is getting 'lost in
translation' between my ADO Stream and writing chunks to the field for

I want to generate a series of number in a Form as reference number
automatically. It likes 0804-0001, 0804-0002,........................ in
each record.
How can I do?

I have this situation (the example code it is in visual basic 6):
   Dim sSqlSelect As String
   dim vFields() as variant
   dim vValues() as variant

Hello.  I've seen this topic posted before, and have seen the following code
in several places:
===============
Option Explicit

I am planning to use Access 2007 with password protection to store and
access important company information using VB program.
I am worried about the security of Access 2007. The password protection of
earlier version of access was so easy to break.

VB6 app
Trying to setup an UPDATE statement to modify all records in a single column
(Access db).  Everything works fine until it hits the UPDATE statement (no
errors, but no updates made to the table).

I doing a assignment at college, that requires me to create a
application that sells d.v.ds, calculates the income and quantity
sold.
I'm completely confused!

My application access an mdb database using dao360 and works fine in the VB6
SP6 IDE. When I create a deployment package and try to run it it fails at the
first attempt to access a field value. The recordcount is correct and
.movefirst works, but trying to get the data throughs ...

I doing a assignment at college, that requires me to create a
application that sells d.v.ds, calculates the income and quantity
sold.
I'm completely confused!

I am not getting a response from the .Recordcount in ADODB.Recordset
It opens the file ok and you can see the first record but the .Recordcount
shows -1
Help Please

I am not getting a response from the .Recordcount in ADODB.Recordset
It opens the file ok and you can see the first record but the .Recordcount
shows -1
Help Please