VB Forum / Database Access / July 2004

I have a VB6 app I am developing that connects to an Access 2K DB.
Each time that I try to identify the 'RecordSource'- after identifying
the database when placing the DataControl on the form, I get the error
"Data Access Error". 'Help' takes me to: "Data Access Error (Error

hi...
i hve one question..
i would like to make a small autoupdate feature for my app...
i would make one app to store myapp.exe file in sql server... using ado

I have the following code in my VBA app:
tblLotsRS.Open strSQL, gobjConnection, adOpenForwardOnly, adLockOptimistic, adCmdTable
         where strSQL = "SELECT * FROM tblLots WHERE BufferID = 1"
I cut and pasted the SQL string in a query in Enterprise Manager and ran it without a ...

I am learning how to do a dataset in VB.net and when I go to run the program
I get an error with
InitializeComponent()
The error is

I'm trying to set up a dialog box that allows users to enter columns in a
table they've defined
However, I'm getting an error - I'm creating the SQL statment:
ALTER TABLE NewOne ADD lname varchar(50) NOT NULL

I have the following code in my VBA app:
tblLotsRS.Open strSQL, gobjConnection, adOpenForwardOnly,
adLockOptimistic, adCmdTable
         where strSQL = "SELECT * FROM tblLots WHERE BufferID = 1"

Something about connection VB6 with Oracle. How to make safe connection
between program written in VB6 and Oracle? I don't want to include user
connection (oracle) and password into program code, so it should be
somewhere outside. Question is where. Of course user and password ...

I have marks of students stored in a tabular format in the maks.htm file (
file attached and codes included below )
Will ado of vb be able to retrieve the marks directly?
TL

I'm using VB 6 as part of Visual Studio 98 on a Windows 2000 SP 4
machine.  I have a VB 6 form, with a DataEnvironment that's connected to
an Access 2000 database.  There is a FIND button that performs a search
based on which of three option buttons in a control array is selected ...

Does anyone know how to stop Microsoft Access coming up with the 'You can't
save this record at this time' dialog when you set Cancel = 1 on a form's
BeforeUpdate?  I'm trying to create a form where you can just add a new
record, and I'd like to have a cancel button, but obviously ...

I our application we have a global variable (rdoConnection) that we
initialize on load. This is open all the time.
   Set enOrdre = rdoEnvironments(0)
   enOrdre.CursorDriver = rdUseNone

hi gurus;
Whenever i try to get recordset from execute method of ADODB.Command object
i get readonly recordset, even though i have set Connection CursorLocation
property to adUseClient. But when I run this stored procedure with

My application designed with VB6.0 is connected to MS SQL Server 7.0.
Server has password for sa login. The VB code for connection is next:
Dim Conn As ADODB.Connection
Set Conn = New ADODB.Connection

I am creating a New table via DAO. But the field named RecNum needs to have
thew attribute of AutoIncrement. How do I do this correctly??
With tdfPickTicketLog
       .Fields.Append .CreateField("Type", dbText, 8)

My application designed with VB6.0 is connected to MS SQL Server 7.0.
Server has password for sa login. The VB code for connection is next:
Dim Conn As ADODB.Connection
Set Conn = New ADODB.Connection