VB Forum / Database Access / July 2004

Dear Friends,
I m creating app in vb and Access 2k.
using dao 3.6 refernce for it. I have two question about deployment and compatibility with OS and Office suite.
1) What  files i need apart from dao36.dll , such that my app run on OS like win95, win98 etc ???????.

Can anyone give me some sugguestions here.
Connection is declared at the start of the application
Set rsFZReport.ActiveConnection = conn
Then a function repeatly opens recordsets like this -

Hi !!
I have a problem on using Microsoft Access to update a record in my VB
problem.
I am using ODBC to connect to my DB.

Hi !!
I have a problem on using Microsoft Access to update a record in my VB
problem.
I am using ODBC to connect to my DB.

I 'm trying to invoke a stored procedure using ADO from a web page. For
brevity, I have a stored procedure that creates a temporary table, does some
computations and then writes the result to the temporary table.  Upon
completion of the stored procedure the contents of the temporary ...

I am going crazy trying to figure out how to roll out an upgrade to my
product which reflects database changes to an Access 2000 database.  The
application uses VB6, ADO, and Access 2000.
I've made changes to the database such as adding a column here, removing a

Can anyone explain in plain english how to deploy a vb.net application that
has a SQL database
using MSDE ?
I have found so many snippets on line and in the several hundreds of dollars

I have an application built in VB6 with an Access 2000 database using ADO
for data access.  It works well except when I think about releasing my next
version with database schema changes and thinking about how I need to
provide components with the installation.

Does anyone know how i can filter(SQL statement) duplicate field record and
show it only one time(not deleting it)? Thank!

Here is the relavent code up to now:
--------------------------------------------------------------------------------
Dim lcSelect As String = "INSERT INTO tempFile SELECT *  FROM stktrn"
       Dim ConnectionString As String = "workstation ID = LITTLERED;"

I am using the Data Environment Connect Designer for the first time. I
am confused about the use of the DataMember property for a text box on
my form. I want the DataMember to access a query (which is listed in
my Visual Data Manager), but the DataMember property only has a

Hi Group,
I am having trouble applying the following filter to my recordset when the
database column value is something like O'HARE or MCCOY'S or O'NEIL
ETC......

Can someone tell me how I can modify the following query so that the
resulting record set contains at most the first 10 records that meet
the criteria?
SELECT * From tblA Where (UserId = " & UID & ") " & _

I am working with a VB.Net application data form (created by the data
form wizard) and the text controls on the from are bound to a dataset.
Two of the fields are Dates which are appropriately typed in the back
end Access database as Date/Time.  I have a text box field (not a

I'm usind the shape provider to retrieve a hierarchical disconnected
recordset. Some fields are foreign keys to other tables. I've looked through
the Properties collection of the Field objects, but BASETABLENAME does not
refer to the related table, and BASEFIELDNAME is not the field ...