MS Access not responding when opening a table

[mhegazy]

Dear guys,

Is there a reason for MS access to be not responding to open table order.

Upon trying to open a table in the datasheet view it doesnot while it do in the design view.

Would you please help on that?

Thanks in advance
mhegazy

[TheSmileyCoder]

Not responding how exactly? Does it freeze up? Or does the form load, but without the information you expect?

If the table has been corrupted you can try to do a compact and repair operation, then try again.

[zmbd]

also... any errors tossed by access?

[twinnyfo]

mhegazy,

Does the table EVER open up or does the entire DB freeze? If it is a linked/network table, sometimes there can be significant delays, for whatever reason.

[TheSmileyCoder]

If it is a linked table, try opening the table directly in the backend, and see what happens.