VB Forum / Database Access / October 2004

I got this problem, I can't delete a group of records, from an Access 2000,
data base.
The Error code is 3251, in runtime
"current recordset does not support updating. This may be a limitation of

how can i with VB6 alter the type of a colom from NUM INTER into NUM DOUBLE
?

I am using VB 6 and Access.  I have a datagrid controller.  I would like to
be able to click on a row, then click (command button) 'edit' and open the
information in a new form.  Is this possible?
Thanks

VB6. Access 2000. ADO 2.8
I have noticed that when I write a record to an Access database it doesn't
appear for some 3 seconds which is far to long for my application. Are there
any techniques, switches, parameters that would speed this up?

im genereating a recordSet from SQL server 200 & VB6( SP5 ) using the
following code
      Dim DuplicateRS As ADODB.Recordset
      Set DuplicateRS = New Recordset

Is there a way to query and find all available servers on the network
WITHOUT SQL-DMO?

I have a simple app and Access database.  The database needs to be password
protected.  I have no problem accessing the Database without the password.  
But once I add a password (via access) I get issues with both Workgroup and
invalid user/password.

m using ado 2.7 in my app and packaged using installshield .
when i install my setup in win 98 it prompts me "SYSTEM REQUIRED TO BE Y2K
UPDATE BEFORE INSTALL " and install fails.
what is y2k updation ?

We are using VB6/ADO with Access. We have a standard header/detail
relationship between two tables (please see below) and need to perform a
seek to the detail records. However, one of the lookup fields comes from the
header. For example, we want to seek on CONTRACT_ID / PART_ID  but

Hi!, My cordial regards, I have this problem... In some computers, my
aplication gave me an error msg when I'm trying to add or update records.
Back in time, I use the Adodc components to access and control the databases
and to solve this problem I constantly refresh the Adodc ...

Is it possible to display all the data in the database? I tried...
txtS.text = D.fields(0) + " / " + D.fields(1) + " / " + D.fields(2)
It does display out the first line in the database, but I'd have to add a
'MoveNext' if I want to display another one. Is there a way like...

I've been using ADO for a few years now and now I need to simply open
an access DB using DAO3.6 which has is password protected.
set dbtemp = opendatabase("MyDB.MDB",False,False," ;pwd=mypass")
I get an error about "cannot find...ISAM" something, something...

I use VB6 and Access97. Do I need an ADO-control to be able to use SQL for
inserting , deleting and retrieving data from an Access-table?
I now use a DATA-control. The Access-database is located on the local host.
What is a good book or site for VB and databases?

Is there a way to change the sort order of an existing Access database and
refresh the records according to the new sort order using ADO?
Thanks,
Ivan

Can anyone recommend a book or source of info on how to use VB.NET with MS
ACCESS.
Visual Basic 5 and 6 had loads of such books describing how to carry out all
of the every day db activities