Help, Slow Tables?

[GoinDeep]

I've got a strange problem, all the tables which I've created in my latest database "DB-B" are slower than molases. However, if I import a table from one of my previous databases "DB-A" the imported table is lightning fast.

For example:

I've got a simple table created in DB-B, 9 Records, 1 field. It takes over 8 seconds to open this table.

Now I have a complex table originally created in DB-A then imported into DB-B, >177,000 records, 35 fields. It takes less than 1 sec to open the table.

All tables created in DB-B are unreasonably slow, does anyone have any thoughts on why this is?

Thanks in advance for any help!

 

[Fuga]

There could probably be any number of reasons. Have you tried compacting and repairing the db?

Fuga.

 

[GoinDeep]

Yes, But I think I'm on to something, when I view the properties of all the slow tables the Subdatasheet Name = (Auto); If I change this to (None), like the faster tables, they seem to open just fine.

Now I have to fiqure out what "Subdatasheet Name = (Auto)" means; and determine what impact making this change on all table will have?