VB Forum / Database Access / July 2003

Can I use VB 5.0 or VB 6.0 with Windows XP and Office XP? Or do I have to
have VB.net? Regards. -Guy

I've tried to respond several times, but my response never gets posted. So I
re- posted.
AddressID is a long, and although a foreign key, the relationship is not
setup.  In the VB DLL

1.      com.commandtext = sql_query
        Set  Rs = com.execute
2.       Rs.Open  sql_query, myConnection
Is there any difference?

Thanks Graham for your response. This is my connection
string is the Deleted=No the attribute you were talking
about?
Driver={Microsoft Visual FoxPro

I have problem with the DISTINCT in SQL statement.
The coding like this.
sS ="SELECT DISTINCT t_ID FROM T"
rsS.Open sS, cn, adOpenKeyset, adLockOptimistic

Its my first time using oracle, i have inherited a large
(gigs) db and it has a stored function. i am familiar with
odbc etc etc and i mainly prog for SQL/Access
so far all my attempts to access this function have

People,
   Im trying (in SQL) to compare a user given start and end time to see if
it falls in between a start and finish time in a database.
I don't want the results if the start time or end time lies between these 2

BlankHi, I'm writing a VB program (with DAO3.6) to access 2 Access
databases.
One db is user-level secured (with workgroup inf. file).  Another one is
non-secure.

Anyone point me in the right direction on how I can accomplish this?
Thanks, Rob

I am trying to create a MDI program in VB.NET 2003.  My problem is that I
have declared all my ado connection information on the main form.  It works
great and I am able to manupulate the data.  But how do I give my child
forms access to the dataset and connection and stuff?

Sometimes when I use AddNew the added record is not at
the end of the Access table. It may appear at the
beginning or anywhere. How do I ensure the added recorded
is always appended to the end of the recordset/ Access

The SQL command below works inside a SHAPE command for
Access, but not the SQL Server SHAPE provider:
SELECT mwEventWfStage.*, mwEventWfStagePermissions.*,
mwcRoleType.*  FROM mwEventWfStage

I'm new to SQL Server, hence this trivial question. I have an
application in VB 6.0, database- SQL Server 7.0 and I use ADO for
connectivity.
For reporting purpose, I create a global temp table (##) from the vb

I am not sure I am asking this in the right newsgroup and if not please
point me in the right direction.
I am opening an Access database in VB 6 and am able to delete the
information out of a record, leaving one field, which is a Unit number and

I'm not sure if this is the correct forum/Group for this question, if not,
please direct to the correct NewsGroup.
Thanks...
From an external application, VB.Net, VFoxPro, VB6, etc, I would like to