VB Forum / Database Access / March 2005

I am upsizing from Visual FoxPro to MSDE and I've run into a problem.
When I do a Recordset Open with an "order by" clause it only opens the
Recordset with CursorType = adOpenForwardOnly and LockType=adLockReadOnly
even though the open method specifies adOpenStatic and ...

Hi group,
I'm trying to run a query against an Access database in VB:
rsClients.Open "SELECT Client, SUM(Client) As NumItems FROM Problems WHERE " & _
               "TimeStamp Between #2005-03-02# And #2005-03-03# GROUP BY Client " & _

I have detached a Database from SQL Server 2000 called "pubs.mdf"
Now, I need to connect to "pubs.mdf" from my VB 6.0 application using
ADO.
I do not have MSDE or SQL installed on client machine.

I have an app which requires several connections to SQLServer. I'm
using this code:
--------------------------------------------------
CS$ = "Provider=SQLOLEDB.1;"

I am currently a program that needs to add data an Access Database that is
in version Access 2000, the problem is that this program will need to run on
more than one platform and write data to a different machine.
There is a different version of Access installed on each of the

I am using VB6 + SP5 together with Access 2003 database.
I connect to the database from the program by using ADODB object.
Until now I connected to the database without a password and it worked OK.
But when I created a password to the database , I get a run time error.

I want to access MS ACCESS 2003 database over network and i don't want to
access it without using the network sharing feature.
How can this be done?
Thanks,

hello i enjoy playing with access and vb and built a db for a friend however
i wanted to make it more visual . ive replaced all the buttons with flash
buttons , but im having a problem with toggle buttons.  Im after useing the
vars strored on a normal toggle eg true/fase etc.  any ...

Can anyone help with this one:
I have a datagrid control on a form with its DataSource property set to an
ADODC control on the same form.
I have no problem displaying data with the datagrid if, during the form

ASP Stored Procedure and Disconnected Record sets.
How in ASP (not ASP.net) is a disconnected record set created from a
stored procedure ?
This question has been asked before but i have not found a valid

I am using VB6 with an Access 97 database, with up to about 6 users requiring
simultaneous access.  There is no security on the database.  I have
implemented my own record locking protection.  How do I ensure that users
will not be locked out of the database ?

Looking for some ideas ? ADO / RDO ?
I need to develope a visual basic application that when a user launches the
application it checks to see if the datase for the user is created if the
user does not have a DATABASE it creates one then creates a table in the

   Question,
Is it possible to use a AND in a find string, somthing like this:
 Db.recordset.find("Collum1=London AND Collum2=Amsterdam")
In this syntax is doesn't work, is there a way to do this??

I have simple access database, I have two forms...first form creates a
criteria for data to be displayed on second form. i.e. based on selections
the recordsource for the second form is created and passed after opening the
form in the form of a sql statement select item1, item2, ...

I am developing a Smart  Device app to run on a handheld scanner.  I can
SELECT rows with the following:
       Dim mySelectQuery As String = "SELECT ProductName FROM Products  
Where ProductID = " & Me.txtDcdData.Text