Error 80040e09

[LittleMan]

I can query one of the tables in my database (AllBands) but when I try to query the other one (AllTerm) I get the following error message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e09'

[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'AllTerm'.

/qq_results.asp, line 23

Why?

The page is www.presidentsgroup.ca/qq_results.asp

[LittleMan]

Part II of this post:

I can get queries to run when they are calling values from tables that have cell row counts of around 7,000. I'm running into a problem querrying a table with 37,166 rows. Does anyone know if there is a cap as to how large your tables can be?

-Ryan.

[awasson]

Hey Ryan,

What does your query look like. If it's a word (string) that you are querying against it probably needs to be handled a little different in the SQL statement. ie:
'"&word_variable&"'
"&number_variable&"

As far as table size goes I'm not sure, but Bud, or ~no_mac_jack probably have an idea.

Does that help?
Andrew

[LittleMan]

The table is set up the same way that the other one is and so I was just trying to run a SQL query (SELECT * FROM AllTerm) like we had been doing in the other examples. It works for all of my other tables but not this one so I'm thinking that it may have something to do with size.

-Ryan.

[LittleMan]

Just in case someone ever searches through these posts because they are experiencing a similar problem, I spoke with my host and they do in fact put a cap on the number of table rows that are allowed - they suggested spliting the table into several smaller ones ... I did it and it worked.

-Ryan.

[awasson]

good call,

Thanks for completing the info,

Andrew