VB Forum / Database Access / June 2004

Ok I'm adding a button to my database...a very simple database what I want
to do is type something in a text field hit the button and find what I typed
in the text field....I know its probably a newbie question but can anybody
help

H
I've been working with Access97 databases for some time now (In combination with DAO / VB6 app) and some functions related to replication is a bit slow, will this improve if I upgrade to Access2K
Database structure is really flat, sizes around 65MB, approx 10 members in a ...

i have a problem with update a recordset. The field 'Id' a autoincrement
field (without double values) become a number the are alredy in the table.
Example the field become automatic the number 72, and in the table we have a
same recordset with the value 72.

I have a database table in MS Access with many records.
I use some VBA in Excel to delete some of these records.
But when I try to delete many records I get the error :
   File sharing lock count exceeded.

When my program is installed onto a computer running win 98, the program cannot write to the access 2000 database. Works great on XP.
Can anyone tell me what files my distribution package is missing
Thank
CM

I'm a newbie to VB, trying to transfer over my VBA/Access skills.  I'm
trying to set up two listboxes/datagrids (not sure which control to
use), each with two columns.  The controls will be used to select one
or several values in each case.  The first control ("choose one or

List:
I've a query works correctly on my test dataset written one of two ways:
' All the AccountAccess records that have a matching user over here
SELECT AccountAccess.* FROM AccountAccess, [User List] WHERE

I am using winXp,VB6 and Access2000.
In the Data Form Wizard the open command failed with message: "Unrecognized
database format."
What do I do?

I have recently been tasked with implementing a MySQL database and writing a
data retrieval program using ODBC to interface with MySQL.
I am familiar basics of MySQL and ODBC, but I have an intern performing a
majority of the work and they are new to both.  We have plenty of ...

I want to develop an ODBC driver to connect a normal windows application to
a middleware product.
I can't find any examples or hints with regard to ODBC driver development.
Here are the questions:

I need a  report based on a query stored in a .MDB Database
the query has an input requirement of Student_ID. which returns only
those rows containing THAT student
if I remove the input parameter, that report just shows ALL Students!

Here is the part where the problem lies
SELECT Bills.*, Bills.ClientID, Bills.AppID, Bills.StaffID,
Bills.TotalSpend, Bills.Tax, Bills.BillID, Bills.ServRend,
Bills.ProductsRendered, Bills.WeekEnding, Bills.Satisfaction, Bills.Date,

The application I am maintaining is written in VB 6 and it uses ADO v2.7 to access databases in SQL Server2000.  The database connections and several recordsets are globally declared.
When a transaction applied to one of these databases is committed, the next time one of the ...

there is a vb application which works with the access database on the
network. Database has close to 100K records. it can be up to 15 users
working simultaneously. users do lots of database searching, filtering, etc.
all the data in the database don't change except one yes/no field, ...

I've created a small program that I'd need, but have just one trouble. Have
to say that I feel extremely stupid.
I've written to a text file (sequential) some data like:
   1