VB Forum / Database Access / November 2004

Is there anyone with experience building a multi user database app with
visual basic front end (as windows app on the pc) and mysql back end
(somewhere on the internet)?
Is this a good choice?

Using VB6 and ADO, I'm constructing recordsets with SELECT statements.
My source is comma-delimited .txt files that have well-ordered rows and
columns, but no headers. So my resulting recordsets also have no headers.
My question is, can I manipulate these recordsets in SQL by ...

Greets, All
Converting array formula to work with datatables/dataset tia sal
I finally completed a formula I was working on, see working code below.
I would like to change this code so it will work with a variable mutl-

I use the event following:
Private Sub Connect_WillConnect(ConnectionString As String, UserID As
String, Password As String, Options As Long, adStatus As
ADODB.EventStatusEnum, ByVal pConnection As ADODB.Connection)

I've made an Access DB containing a table named Orders with a field named
DeliveryDate
This field is a time/date field (short date)
When i use a query to find a record, the query works fine only when i query

Hello, I'm in the process of writing a multi-form VB6 application that will
use ADO to access a SQL Server database.
The main form basically has a datagrid and list a bunch of items.
The user can click on an item to open another form to edit the particular

What is the connect string to connect to paradox.dsn (odbc)?

I am looking for sample VB.net code for working with Access 97 database. I
know how to work with SQL but never work we access. Any help is very much
appreciated.
Al

Does anybody know the best practices to support multi-users. In my case I
have a client application installed on several machines which access a sql
server database.
I tried the pessimistic locks. Then if somebody else tries when a data is

I'am new to database programming so please be patient.
I created a database with one table (two fields) and one query (both fields
from the table and sorted)
Now i'd like to run this query from my VB6 application with a parameter.

Hello --
I have a Login form that I have written using VB6.  Everything works, but I
do have a couple opportunities, if you will.
Currently, I only have a Username and Password text box.  When the user

I have an Access 2000 database that I want to open for read only.  It uses a
system file so I figure the easiest way to open this is to use an ODBC
connection because in the ODBC driver you can specify the system database
etc....

I'am new to database programming so please be patient.
I created a database with one table (two fields) and one query (both fields
from the table and sorted)
Now i'd like to run this query from my VB6 application with some input.

Using  a field in a single report each with different crieteria
Hi,
i got stuck whent trying to do the subjected.
i have two tables called

I'm making the transition from VB6 to VB.Net and decided I'd FINALLY try my
hand at database programming.  I purchased "Database Programming with VIsual
Basic .NET and ADO.NET" by Sams Publishing, and I'm stuck in the first
chapter.