VB Forum / Database Access / September 2004

I wanted to see how the Repair Database works.
The only thing is that I don't have a corrupted database to try it on.
I created a small database (50KB), added about 50 records, tried turning off
the power while adding, but the database won't corrupt.

is it posible to run mdac v2.0 on windows 2003 or on a server with .net
framework installed?

Good day all, Quick question about Datasets
If someone can point me to a site/manual/etc where i can get the following
information i will be very greatful
My program grabs a set of data from SQL and fills a dataset,

John -
I don't multi-task well, but when on task, I am totally absorbed.
I need direction to take further action for you, or else I need to move
on to other pressing projects we have. I may not be able to jump back to

I had a program that worked. I went into it to make some changes. Now it
fails with:
ActiveX component can't create object
I made a very simple program that exhibits the problem

I am now researching how to do migrate the LastModifed property
in the DAO recordset to its equivalent in ADO.
The DAO code is something like this
<open recordset rs>

When I try to connect to my *.mdb database during the debug  I get this run
time error...
run time '-2147467259(80004005)'
Database format unrecognized....

I have to connect a db to a form...and i'm trying to use ADO. I'm not
practical in VB...and in English too..so be patience!
Well I've created a connection (i'm not sure if it's right...)
Private rs As ADODB.Recordset

I am using the Microsoft Data ADODC control bound to the Microsoft DataGrid.
I am connecting to an Oracle DB and retrieving about 90,000 records and it
is
taking approx. 4 minutes to retrieve them.

i've made a VB where a want to check the date from a database.
when the date is 6 or 06 it is not working, when the date is greater then 10
is is working.
my windows settings are for chort notation dd/mm/yyyy also in the access

I am working with Access 2003 and have a button with an "on click" event
which copies the contents of a query to a new excel spreadsheet:
objDB.Execute _
 "SELECT * INTO [Excel 8.0;DATABASE=" & strExcelFile & _

I need to get the value of an auto increment field after I add a new
record to a database.  The database is MySQL 4.0.  I'm using Access
2003.  I know I can just move to the last record after the update as
follows:

I have a user who set up a DSN using Win2k. He cannot setup the password in
the DSN
setup. How do I pass the password in my connection string?
Here is my connection code:

I'm trying to add functionality to a VB 6 application allowing
customer service to add a customer number to a new customer.
Customers are added to the database by sales personnel, and a
prospective customer may have multiple rows due to projected orders

I'm trying to determine the best way to lookup about 100 string values in a
dataset that could eventually grow to 500,000 records; the data will need to
be looked up about 10,000 times per day. The records are pretty simple -
basically a text string and a corresponding integer value ...