VB Forum / Database Access / January 2005

i have the following problem:
I have a datagrid that's filled with a recordset.
When the users doubleclicks a record, a detailform is shown with all
info about the record.

Hi all... wonder if anyone can give me some beginners help?
I am experienced with MySQL and PHP, no problem there! BUT I now want to
build a VB6 app that connects remotely to the MySQL database performs a
query and returns the result so I can use it.....

Hello group!
I'm very much new in database programming. Currently I'm developing
softwares using MS Access as backend.
I want a new database background like Oracle or something which is more

I need to update a set of records in SQL server table.
But due to neccessities, the number of records on the screen can be
different from the number of records in database.
If a record  exits on database, I need to update it. if it doesn't I need to

I am new to VB and I'm using VB 6. I am trying to check if a database
exsist, if it doesent, create a database and add one table with a few fields
from the code.
I can check if its there but can't create it.

We are still using VB 6 not .net.
I have a database on our web server that I would love to access from a
Visual Basic program that runs local.
Is this possible in VB 6?

An application used by several users will at odd times come with the message
that a database is already opened exclusively by user "admin' on machine
"whoever'.
The only access that these users are doing is reading various tables - no

how i can get default value in a field ? in .mdb in sql server in mysql..
with asp programming?
my icq # 210139517

With the Visual FoxPro Driver, Delete marks records for deletion but does not
physically remove them from the database.  Attempting to delete records and
then physically remove them via Pack, both in the same subroutine, results in
a "File is in use" error on the Pack statement.

When I connect to MYSQL or MSSQL sever over the internet witch could be
hundred or thousand miles away, do I keep the connection open until the
program closes out or should I open and close the connection each time I
work with data. I am taking about data connection not record ...

I have a ADO recordset problem in VB Code. The recordset is built from a
function retuning ADODB.Recordset.  I use the output of stored procedure of
SQL Server database to populate recordset inside function by using
rs2.CursorType = adOpenDynamic

I want to know if i can store data directly into my project.  I dont have a
need for very complex database, i just want to store some names and some
numbers, but i would like to be able to save them in the application i am
building, i would rather not have to have a database to ...

My project loads lists from a database table into several ComboBox controls.
The program is designed to work with both English and metric measurements,
choice is selected by the user. All list items exist in the database, with a
True/False field that is true if the record belongs ...

I need to know what the differences are between MS ADO 2.5 and 2.8.
Currently using 2.5 and would like to know the arguments to go to 2.8.
Having trouble finding comparison between the 2 on internet.
If anyone knows, or knows a site,

VB6.
I have a Datagrid connnected to an ADO data control.
I'm trying to prevent the deletion of one particular record.
I can detect this by looking a a particular column in the BEFORE DELETE