ADO, VBA, & Hyphens.

[asather]

Does VBA not like hyphens in table names?

This works:

Public Sub myTest()

Dim v() As Variant

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset

Dim thistest As String
thistest = "tblMembershipFeeCategory"
rs.Open "SELECT * FROM " & thistest, CurrentProject.Connection, adOpenDynamic, adLockReadOnly
v = rs.GetRows
rs.Close

End Sub

...But add a hyphen to the table name in the code and in the database....And it doesn't....

Public Sub myTest()

Dim v() As Variant

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset

Dim thistest As String
thistest = "tblMembershipFee-Category"
rs.Open "SELECT * FROM " & thistest, CurrentProject.Connection, adOpenDynamic, adLockReadOnly
v = rs.GetRows
rs.Close

End Sub

 

[DrSnuggles]

You should never use hypens anywhere.
Always use underscores eg. tblMembershipFee_Category.

 

[asather]

...I could smack my database professor.

 

[wazz]

if necessary:

thistest = "[tblMembershipFee-Category]"

http://www.adopenstatic.com/faq/80040e14.asp

 

[asather]

Thank you, Wazz.

I'll run with it.