MS Access Query not working anymore.. help

[pka4916]

ok..



It seems to be happening with 1 table only

if I do select * from maininfo it goes wrong
but if I do select * from myothertable, then it's ok.

I deleted the whole table, and recreated it with only 2 fields, and then it
won't work..

i checked everything, and it seems like it's pulling only the 1st record in that Table.. (but sometimes it's just nothing)

Tried the same table, but then renamed, since it was also in use by the mainform of my Db, but that doesn't make a difference either...

I am so clueless as of why it refused to give me all the results.

1 time, I did get a box all the sudden, about linked table properties,
and I hit cancel, and I got all the results..
I checked, and there is nothing...

[Toyman]

ok..

It seems to be happening with 1 table only

if I do select * from maininfo it goes wrong
but if I do select * from myothertable, then it's ok.

I deleted the whole table, and recreated it with only 2 fields, and then it
won't work..

i checked everything, and it seems like it's pulling only the 1st record in that Table.. (but sometimes it's just nothing)

Tried the same table, but then renamed, since it was also in use by the mainform of my Db, but that doesn't make a difference either...

I am so clueless as of why it refused to give me all the results.

1 time, I did get a box all the sudden, about linked table properties,
and I hit cancel, and I got all the results..
I checked, and there is nothing...

Have you tried to recreate the table directly in the front end part of the db and run the code?

[pka4916]

I FOUND IT!!!!!!!!

This is really stupid, but I always had a primary key in my tables with 2003
Access 2007 doesn't like it for some reason.... so I removed the primary
keys and now it's working just fine..

Why would that be??

[Toyman]

I FOUND IT!!!!!!!!

This is really stupid, but I always had a primary key in my tables with 2003
Access 2007 doesn't like it for some reason.... so I removed the primary
keys and now it's working just fine..

Why would that be??

I am glad you were able to resoloved you problem. Was the primary key an auto number? What was the name of the field?

[pka4916]

I am glad you were able to resoloved you problem. Was the primary key an auto number? What was the name of the field?

It is indeed an Autonumber, and the name is Callnumber