Permissions problem

[John Humble]

A colleague has recently upgraded from Access 97 to MS Office 2000, under
Win 98 in both cases. He did a complete uninstall of all old Office
components before loading the new version. His Access 2000 opens OK and
lets him create and save tables in design view, however the tables so
created refuse to display in datasheet view. One clue, which may or may not
be relevant, is that the Permissions Window under Tools>Security>User and
Group Permissions is empty. It therefore seems that there are no users in
the Admin group. How can one get round that one? Any suggestions anyone?

Sorry that this isn't quite the right newsgroup but it looks like the
nearest.

TIA

John

 

[Chris Kennedy]

Hi,

You wrote:
"however the tables so created refuse to display in datasheet view. One
clue, which may or may not
be relevant, is that the Permissions Window under Tools>Security>User and
Group Permissions is empty."


Does this happen in every database. My guess is that it's database
specific (corruption).

Thank you for using the Microsoft Access Newsgroups.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

 

[John Humble]

Hi,

You wrote:
"however the tables so created refuse to display in datasheet view. One
clue, which may or may not
be relevant, is that the Permissions Window under Tools>Security>User and
Group Permissions is empty."


Does this happen in every database. My guess is that it's database
specific (corruption).

Thank you for using the Microsoft Access Newsgroups.

I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Eric Butts
Microsoft Access Support

Thanks Eric. Sadly, it's not that simple. Access 2000 will not allow
datasheet view in any databases, new or existing and including even
Northwind, on the offending machine.

We have:
1. Installed Access 2000 with all options.
2. Started Access but without trying to open any database
3. Entered Tools > Security>Users and Group Accounts
USERS - name field is blank,
Available Groups )
Members of ) are both blank.
GROUPS - name is blank

The result of all this is that we have no privileges to open or use any
databases, be they existing or new.

We have completely uninstalled Office 2000 and all its components, and
re-installed them. Regedit was used to clean the register. None of this
made any difference. We're now fresh out of ideas other than re-installing
Windows and starting again, which the user is understandably reluctant to
do.

Removing Access 2000 and installing Access 97 produces an A97 installation
which appears to work correctly, but the user wants to use A2000.
Everything is running under a fully patched/updated copy of Win 98.

John