A user recently asked me, which stumpted me, but here goes it. When the tables are opened, it doesn't maximize, so its done manuallly. 97 doesn't save the last setting. If he were asking about a form or a report, I could invoke the Docmd.Maximize, but where would I do this is a table.

Sorry, but you lose control when opening tables. A user should NOT be opening tables directly, but using forms.