VB Forum / Database Access / March 2007

i'am working with MS 2003 Server and MS Access 2002 and i have problem
with my VBA code.
I tryied the following:
Created a module called "Input"

I'm trying to optimize some very old code, and I've hit a stumbling block. We
use Access as our frontend, and SQL Server as our backend.
Here's a code fragment from the old implementation of a search for a
specific record:

OK so I've downloaded and installed this 1.7MB wonder, but now what?
I just wanted a nice easy to deploy db to use with my VB 6 app and although
the size is now great it doesn't seem to be doing much else.
Nothing in the start menu, sys tray, desktop, etc.  Just a folder in my

I have a visual basic application(no source) which connects to ms jet oledb
access db file.  When I moved this file to a different location, I get a
prompt asking me to change configuration.  Specifically, "please enter ms jet
oledb information ....".  Once I change the file path ...

I'd like to know why the copyto method in the System.DataRowCollection
does not copy the dataset to an array using the following syntax:
Thanks,
Chieko

I've a street database in DBase 3 format (it's about 215 Mb) WITHOUT
AN INDEX FILE (I've created a CDX file with FoxPro).
I've tried all possible kind of Driver to access it, but the execution
times are enormous!!

I have an extensive .wdb file, created on  windows 98FE.  When I make a copy
on a cd and then try to open it in windows xp, I get the message that the
file is "in use" and behind that message another message which reads "the
file is corrupted".

I'm creating an app that needs some kind of data store to hold a number of
things, in particular questions and answers.
My plan was to use an Access DB to hold this info and then use ADO to
select, insert, update and delete the data between my vb app and the DB, but

I am trying to fetch Primary keys for different tables in Oracle and
Sybase. After doing some search, I found the following code, but I am
not sure how to get the primary key from recSet
recSet = objConn.OpenSchema(adSchemaPrimaryKeys,

Excuse the longwindedness of this... I've tried putting in all the
relevant code and other information that I can.
I have an application written in VB 6.0 which uses DAO3.6 to connect to
a PostgreSQL database and pump some data in.

Does anyone know if there is a way to specify the exact MDB format to be
created instead of just letting the Jet or ACE driver use whever it
determines is the default on a given system. Using the "Jet OLEDB:Engine
Type=5" parm in the connection string does not allow setting ...

Sir,
  when i run my vb program and view any data report
thru a from where i give criteria/option of report,
first time it shows perfectly . After closing the

I am hoping that somebody out there can give me some advice on the following
scenarios and how to deal with it:
Suppose I have a table loaded into a DataSet and there are two users A and
B. Let's assume that both users upload data to the table at the same time so

Is there any difference/usage problems with the following methods of
accessing records in a database?:
RecordValue  = recordset("Record").value
RecordValue = recordset!Record

[If this is the wrong newsgroup, please direct me to the correct one(s).
 Thanks.]
What is the difference between VB as used in Access and VB (or VBscript)
not used in Access?