Weird problem with Access and CR

[gleeb]

I am using CR 10 with Access for some simple reports. I have setup an ADO connection and added my tables. When I get to one table in particular, no fields show up in the field list but all the other tables are fine.

If I try a DAO connection, I get the following error on the table in question: "Could not read definitions; no read definitions permission for table or query".

The table is built just like all the other tables and I tried even rebuilding it from scratch. Any clues? This is the first time I have ever had any problem like this.

Thanks

 

[synapsevampire]

Does seem odd, perhaps there's some proprietary naming involved which is tripping up the connection.

Or perhaps the table has some functionality within such as lookups or functions that is causing the problem, I've never seen that either.

Access has a built in database repair facility, I would make a copy of the database and try that as well.

Try Tools->Database Utilities->Compact and Repair.

-k