VB Forum / Database Access / August 2004

Using VB6 SP5 and an Access 2002 mdb file:-
Could someone please provide a coded example to compact
an mdb file using DAO.
Many thanx.

I have the next code to connect by ODBC to and ORACLE DB and
set a Recordset object with all records in a table USERS:
Private Sub Form_Load()
Dim wrkODBC As Workspace

I used to set the value of CacheSize property for Recordset in my VB
apps(ADO 2.7). What property now I can use instead of CacheSize in ADO.NET?
Any help would be greatly appreciated.
Amin

Hello, I have kind of a rough question, so bear with me. I have a basic
recordset that returns me a set of data from executing a query. I want
to be able to persist not just one but multiple, we are probably talking
100 or so recordsets, to a xslt stylesheet to be processed and ...

I am migrating an application from DAO to ADO and I have run into something
I have not seen before.  The DAO version will execute a query that inserts
records into a table that has a primary key defined, but the ADO will not.
The DAO version inserts 95 out of 100 records, the 5 it ...

Dear Friends,
I wrote a very simple code to read from a legacy DOS File. Code reads the
file byte by byte. These files are created some sort of database program
whose origin I do not know. With alpha data there is no problem. However

       I'm interested in people's comments about "best practice," and
why...
       I have a number of places in my code that I open a recordset, then
loop through it for some reason or another.  Of course, the first thing

We are using:
MainRs.Fields(ColName).AppendChunk buffer
MainRs.Update
to append binary files to Access 97 and this works ok.

I made an options menu where you can specifiy a SQL-database. However, that
menu is activated after the database connection opens. I use
DataEnvironment. My application opens it connection immediately after the
program has started. Before I open the connection, my application asks ...

I have a list view with one subitem.
that subitem contains the numeric data
I have written a code to sort when user click the column header of that
subitem. but the problem is that subitem sort as text not as number means

Winxp/iis5/dwmx/asp/vb/msaccess
I'm trying to update a record based on a cookie existance.
I'm getting this error when trying to load the page
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)

I'm having a very weird problem when I try to dynamically populate a
listview.
I use different queries and some work and some don't. I found out that if
the last field

I want to ask, Can I Get The ID after I insert Data to database?
Is there any other way?
Example:
Table Name : Customer

I have been trying to use the application wizard to mock up a project and
keep running into errors when trying to run the resultant code.  Is there
anyone who has conqured this?  Try a MDI project and a master/detail form.

1. To run a program created using SQL Namespace - is SQL Server or its tools
required to be installed on the machine for this to work?
2. Is programming making use of the SQL Namespace re-distributable, legally?