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!

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

Fuga.

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?