Last week I suddenly could not open Access tables, queries, etc. in
either design or data entry view. If I create a new db, with a new
table, everything seems okay. However, once I try to open the table
then I receive a dialog box (having an explanation mark and "Microsoft
Access" as the dialog title) with "Unknown" as the warning. Macros and
queries can be created, but they will not run.
When I go to Tools / Security / User and Group Accounts then I receive
a warning before it will open that says, "in query expression
'MSysAccounts.name'." I have to click "ok" a couple of time for the
User and Group Accounts dialog to open. When it does, I notice that I
do not have either Admin or User in the group (it is empty), as I
should have.
I've tried "repairing" MS Access and Office. I've completely
un-installed and reinstalled Office (2000 Pro, running on XP Pro).
I've replaced my SYSTEM.MDW file with one from a working pc.
Any ideas on how to fix this problem will be greatly appreciated.
Thanks,
Andrew