G
gramby
I created an Access database with linked tables to a SQL database. I then
used the Security wizard putting myself in the admin group and one user in
the read-only group. I did something wrong as this affected all of my Access
databases.
To remove the security I followed instructions in
http://office.microsoft.com/en-us/ork2000/HA011381181033.aspx. I also
removed the read-only user. I was not able to import from the old database
as it said I didn't have the necessary permissions. The original database
shows that admin is a member of users group, but not the admins group. I am
still a member of admins, but get no prompt to log in as myself.
Before I realized this I set the admin password and then blanked it out. It
was finally able to get into my other databases, but still not this one. I
do have a copy of the db that I can get into. The wizard also made a .bak
version.
The database is on a network drive. The security.mdw is in the same folder
as the db. There is no other version of security.mdw on the network drive,
nor on my harddrive that I can find.
When I go to Tools, Security, the "User and Group Permission" and "User-Level
Security Wizard" are grayed out on this db, but not the other databases.
1. Is there a way to completely remove the security file and start over?
Maybe delete the security file and uninstall and reinstall Access 2003?
2. I only have 3 linked tables and 2 queries in this db, so starting over is
no problem. I am new to Access. Can I safely delete the Access database
without affecting the SQL tables that I linked to? Would I then rename the .
bak to .mdb and be back where I started?
used the Security wizard putting myself in the admin group and one user in
the read-only group. I did something wrong as this affected all of my Access
databases.
To remove the security I followed instructions in
http://office.microsoft.com/en-us/ork2000/HA011381181033.aspx. I also
removed the read-only user. I was not able to import from the old database
as it said I didn't have the necessary permissions. The original database
shows that admin is a member of users group, but not the admins group. I am
still a member of admins, but get no prompt to log in as myself.
Before I realized this I set the admin password and then blanked it out. It
was finally able to get into my other databases, but still not this one. I
do have a copy of the db that I can get into. The wizard also made a .bak
version.
The database is on a network drive. The security.mdw is in the same folder
as the db. There is no other version of security.mdw on the network drive,
nor on my harddrive that I can find.
When I go to Tools, Security, the "User and Group Permission" and "User-Level
Security Wizard" are grayed out on this db, but not the other databases.
1. Is there a way to completely remove the security file and start over?
Maybe delete the security file and uninstall and reinstall Access 2003?
2. I only have 3 linked tables and 2 queries in this db, so starting over is
no problem. I am new to Access. Can I safely delete the Access database
without affecting the SQL tables that I linked to? Would I then rename the .
bak to .mdb and be back where I started?