John
Are you saying you have ULS AND a db password? Or are you having to reset your own password?
I've never had a time when I could not delete a table unless someone was writing to it. A paste errors table is created by Access when a user tries to paste in a record(s) directly into a table and the paste fails. As long as no one else is in the paste errors table.
It sounds like a system table index might have gotten corrupt. Next time try compacting the database or importing all objects into a new database instead of doing all that password hocus-pocus.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
http://mvp.microsoft.com/en-us/mvp/Bill%20Mosca-35852
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
---In MS_Access_Professionals@yahoogroups.com, <jfakes@rocketmail.com> wrote :
I had a strange problem the other day. I opened up a .mdb with user level security (I know yikes!), I saw a paste error table so I opened it to see what was in the table and didn't recognize what it was so I tried to delete the table. I didn't have the option to delete the table. I searched and found several people had the same issue and they had to open the db, remove the password, log out, log in, then add the password again. After I did that, I was able to delete the table. Very strange as I have been using this database for years.
John F.
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (9) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar