Search Key Not Found. Can't Open Table

[markphsd]

I'm unable to open one table in my Project, tblCustomers. I can open all of the other tables, but when i try to open the Customers table it says: "Search Key not Found", or it will say "The stored procedure executed properly but did not return any results."

I can open the table directly from SQL Server. I can open it with views, SP's, and Bound Forms. But not just by clicking on the table.

Any Ideas?


Mark P.

Bleh

 

[cmmrfrds]

Do you have an unique index on the table?

 

[markphsd]

Yeah, I do. I could open it up with sql server, just not Access.

Mark P.

Bleh

 

[cmmrfrds]

How about a primary key?

 

[markphsd]

Yes, primary key is an autonumber.

Mark P.

Bleh