Last post Jul 19, 2008 02:12 PM by Mikesdotnetting
Jul 19, 2008 11:46 AM|Nashua|LINK
I have IIS running on a server at my home while I am teaching myself ASP. I run into a problem often though in which I am not able to edit a table in my database because I am getting this error.
You can't open the table "Logins" for modification.
A qurey or form bound to the table is open, you may not have permission to open this table in Design view, or another user hsa the table open.
Do you want to open this table as read-only?
If you have opened a qurey of form bound to this table, close it, and then try again to open the table in Design view.
It seems like a pretty simple error message except that I don't have anything else open when I get this. As for permissions, that's not it. I am the only user and have gotten into it several times already; it just does this every once in a while. I don't
have any queries at all, let alone running.
Can anyone help me with this?
Jul 19, 2008 02:12 PM|Mikesdotnetting|LINK
As for permissions, that's not it.
Oh yes it is [:D]
You are not actually the only user. When you run a web application on a computer, it's actually the ASPNET account on XP Pro, or the NETWORK SERVICE account on Win2k3 that the application runs under. What you need to do is to apply
MODIFY permissions for that user on the folder in which the database sits. That's so the ldb file can be created
and deleted under that account.
If, for some reason, you have enabled impersonation on the application, it will be the IUSR_machinename account that this applies to instead.