Primary Key in Acces 2007

[pka4916]

Does anyone know why a Primary Key in a table makes a query not work anymore?



If I use like select * from mytable then I get 0 records
and when I remove the primary key for my Autofield integer then I see
all the records.

This was working fine in Access 2003, but in 2007 if refuses to work.
Even created a new 2007 Db, and it won't work.

Any thoughts?

[NoellaG]

Hi,

select * should always return all fields and without any criteria it returns all records. Are you sure there is no WHERE clause somewhere? Could you look at the SQL view and post the SQL-statement?

gr
NG

[pka4916]

Yes, I am sure.

The SQL is Select * from mytable;

I had a different thread about something else, and this was causing all the
problems.