Simple jet SQL query will not work for one table but will for another 
Author Message
 Simple jet SQL query will not work for one table but will for another

Is there some reason that I would get this error
"Object doesn't support this property or method"
For one Access table and not the other

Wont work:
    sqlSelect = "SELECT * "
    sqlFrom = " FROM Blocks "
    sqlQuery = sqlSelect + sqlFrom
    Data1.DatabaseName = gsDatabase
    Data1.RecordSource = sqlQuery
    Data1.Refresh

But will work for :
    sqlSelect = "SELECT * "
    sqlFrom = " FROM Tools"
    sqlQuery = sqlSelect + sqlFrom
    Data1.DatabaseName = gsDatabase
    Data1.RecordSource = sqlQuery
    Data1.Refresh

Any clues would be greatly appreciated.

Thanks,



Sun, 08 Oct 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Willing to work for free....

2. Programmer willing to work very inexpensively

3. Help wanted - willing to pay fair hourly rate

4. A Willing Volunteer to translate WB to VBA

5. A willing person to convert WB to VBA

6. Anyone willing to help HS student?

7. Anyone willing to help HS student?

8. Forms of a willing shape

9. Willing to pay for a searchable Internet Database

10. Anyone willing to be a mentor?

11. anyono willing to give help

12. In need of a programmer. Willing to pay

 

 
Powered by phpBB® Forum Software