Idiotic problem

#1

I'm trying to select from an Access database in VB. There are 5
records in the table but this select will only return 1. I have no
idea why. If I add 'DISTINCT' it works correctly.
Dim rs As Recordset
sSQL = "select name from name_table"
Set rs = oDB.OpenRecordset(sSQL)
Debug.Print rs.RecordCount

#2

"Name" is a reserved word and should never be used for a column name; it
confuses Access because it meant to be used in other contexts, e.g.
Recordset.Name.

--
Allan Thompson
APT Associates/ FieldScope LLC
MS Office Automation / Measurement and Reporting Systems
www.fieldscope.com
860.242.4184

"Kevin" <kcorth (AT) yahoo (DOT) com> wrote

Quote:

I'm trying to select from an Access database in VB. There are 5
records in the table but this select will only return 1. I have no
idea why. If I add 'DISTINCT' it works correctly.
Dim rs As Recordset
sSQL = "select name from name_table"
Set rs = oDB.OpenRecordset(sSQL)
Debug.Print rs.RecordCount

#3

kcorth (AT) yahoo (DOT) com (Kevin) wrote in message news:<eae80cc2.0310081312.5e2cc3b4 (AT) posting (DOT) google.com>...

Quote:

I'm trying to select from an Access database in VB. There are 5
records in the table but this select will only return 1. I have no
idea why. If I add 'DISTINCT' it works correctly.
Dim rs As Recordset
sSQL = "select name from name_table"
Set rs = oDB.OpenRecordset(sSQL)
Debug.Print rs.RecordCount

Actual field and table names are:

Dim rs As Recordset
sSQL = "select player_name from player_name_table"
Set rs = oDB.OpenRecordset(sSQL)
Debug.Print rs.RecordCount

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Idiotic problem

comp.database.ms-access comp.database.ms-access

Idiotic problem - 10-08-2003 , 04:12 PM

Re: Idiotic problem - 10-09-2003 , 07:30 AM

Re: Idiotic problem - 10-09-2003 , 09:11 AM