VB Forum / Database Access / December 2003

I have a table with lots of rows.
I need to show only 25 rows at a time
How do I populate it to a grid with prev/next 25 ?
TIA

I have designed a database application. I need to write a user module for
managing access to each and every function in the application.
(add/edit/delete/etc...)
I have SystemUsers in a seperate table which contains loggin information of

I have a VB program that is run as 10 seperate instances of the same .exe.
They all run on the same PC and hit the same ACC97 database on the server.
As each instance is running it logs its results into the db with a real
simple Insert query using ADO in a wrapper .dll.

I am filling an ado recordset and can not seem to get the right values in
the fields.
Here is what I am doing:
20% discount on an 8.00 product charge should be 6.40

Windows XP SP1
I'm trying to connect to a local MySQL database through VBScript (also tried
JScript and ASP, same result)
connect = Server.CreateObject("ADODB.Connection");

Is it possible to write VB(A) to access an Oracle database eventhough the
Oracle client is not loaded on the workstation?
I want to write a DAO procedure to query an Oracle database, but can't find
any example code.

This seemed to be the most appropriate place to post this problem.
I am trying to write a VB program (I'm a little new to VB) which
incorporates XML. My problem is this: I have an IXMLDOMElement and a for
loop which sets the IXMLDOMElement to a new value every time the loop is

I have a string that I am using to build a SELECT statement, but the string
can contain a name with an imbedded quote (ie, searching for all members
with the last name O'CONNOR)
How can I replace the single quote with a double quote just in the string:

I'm having a difficult time writing a SQL expression that will list
all records from TblA with matching records from tblB where only the
maximum value in a field from this latter table is to be included.
This does not work:

Hi Quick Question.
I am using Data Environment.  In run time, we are assigning a connection
string to the data environment.connection.connectionstring property.
However, the password seems to disappear in the connectionstring and only

I'm using the odbc driver to connect to MySQL and would like to be able to
add a new database & tables using my ASP.NET application. Is there a simple
procedure I need to follow?
Marcus

I have two tables where the fields are the same. I want to be able to :
1) Create a new row in table 2 and populate it with the field values from
table 1, row N
2) Select an existing row in table 2 and overwrite it with the field values

I want to know that can i use MSDE as database server for deploying application. Is it necessary to buy any licence if I use MSDE as database server in Windows 2000 server. Moreover, is MSDE designed for multiple users access like SQL Server?
Million Thanks
Eric

Access is defaulted to save any change updated to records, however, I want
to write a VBA which user must click the "Save" button in order to save or
update the records, if user did not click the "Save" button, the new change
won't update to the Database. How can I do that?

The following code is on a vb6 form using ado to search a
access 2k database.  I have three tables in the database
named "Amtrak", "Unionp", "Other". All of the Tables have
the same