VB Forum / Database Access / October 2004

I have setup a command and want to use a server side cursor with a cache
size of 100.
Using set rs = cm.execute returns a clientside cursor cache size = 1.  you
cannnot change this.  It is by design.

Hello - I'm trying to create an Access 97 MDB as well as tables w/in
the db all programatically from VB - is this possible?  
I've seen examples for creating Access 2000 database BUT cannot create
Access 97 database...

First time poster, please bear with me.  Maybe the post is too long.
We have a library system which uses a legacy (and proprietary) SQL database.
The vendor provided only a very old and proprietary ODBC
driver to achieve read-only external access to the database.

\Private Sub tmupds_Timer()
Dim j As Long
   Dim leng As String
   Dim lret As Long

I could not find a way to retrieve the data type of a
column with ADO.
Is it just not possible ?
Is there another way to do it (for MS Access and MS SQL

We have a VB6 app that ran successfully with a .DBF databse under pre-XP
Windows operating systems with a connection to the Visual FoxPro Driver.  The
app fails under XP when attempting to open the connection.  The Visual FoxPro
Driver is listed in the ODBC Data Sources for the ...

I'm wondering if there is a way using ADO 2.5 with VBScript to return the
names or a collection of of all of the tables in a MS SQL 2000 database.  If
possible, how so? And if not, does anyone have any suggestions on other
methods of doing this?

I have an exe that uses the Find Method.
On some machines it works and fails on others. Same code.
here is the code:
PlaylistClone.Find "ID='" & ptr_OnAir_id(i) & "'", , adSearchForward,

In SQL Server you can use @@IDENTITY to return the
Identity value of a newly added record, but how can you do
this in access. I would like to be able to return the
value of a Primary Key of a newly added record.

I have windows xp oulook 2003 and i create connection string
Provider=Microsoft.Jet.OLEDB.4.0;Exchange4.0;MAPILEVEL=Personal|;PROFILE=Out
look;TABLETYPE=0;DATABASE=C:\temp
I connect  and then open Recordset with SQL

Thanks Veign for your advice. It worked well. I then tried to double up when
using the Find method (I was trying to search through a Recordset for a
record which had an apostrophe) but it did not find the record. However using
the hash symbol did work. For example recordset.Find ...

Dear Group,
I have got 2 forms FormA and FormB. FormA's data is Found in TableA and
FormB is Found in TableA & TableB through a Query we will call Query1. The
relationship is a TableA (one) ==> TableB (many). When I go from FormA

I know Find method of ADO but. it can find in either forward or reverse
direction.
i.e. total records = 500 , absoluteposition = 200.
if  search text  before 200 or afterwards.

If I log on to the master database in an SQL server, is there a way for me
to tell if a non-master database has any connections to it?
VB6
ADO

I have the following code which should copy a table form one access mdb to
another, however it doesn't work because the CopyFrom.mdb has a database
password and I can't figure out how to pass it or tell jet what it is.
Any ideas?